Creating Aggregations Post Deployment of Cube ?

Question

Creating Aggregations Post Deployment of Cube ?

syedathariqbal

Hall of Fame

Points: 3175
More actions
March 11, 2014 at 3:41 pm

#290752

Hi Friends,
Is there a possibility to create Aggregations after the Cube has been deployed. I recollect that I have read something along these lines but can't recollect it in entirety.
Googling didn't helped either. :hehe:
Regards,
Athar

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 1

You create the aggregations and redeploy the cube?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

syedathariqbal Hall of Fame Points: 3175 More actions · Answer 2

Hi Koen,

Yes I can do that. What I really wanted to know was, "Is there a way creating Aggregations outside BIDS" ?

Perhaps NO.

Athar

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 3

You can design aggregations with XMLA, but I believe the designer will be more straight forward.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

sneumersky SSCertifiable Points: 7667 More actions · Answer 4

BIDS Helper has a nice add-on utility "Aggregation Manager", but that is technically still BIDS.

SSMS has an "assign aggregation design" feature that assigns existing designs to other partitions.

http://technet.microsoft.com/en-us/library/ms181200.aspx

Once you do complete these actions, I think a ProcessIndex will save you some processing time. To my knowledge you would not need to fully reprocess the cube afterwards.