Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Creating Aggregations Post Deployment of Cube ? Expand / Collapse
Author
Message
Posted Tuesday, March 11, 2014 3:41 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 9:19 AM
Points: 108, Visits: 449
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.

Regards,
Athar
Post #1549961
Posted Tuesday, March 11, 2014 3:53 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:50 AM
Points: 13,255, Visits: 11,036
You create the aggregations and redeploy the cube?



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1549965
Posted Tuesday, March 11, 2014 4:03 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 9:19 AM
Points: 108, Visits: 449
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
Post #1549970
Posted Tuesday, March 11, 2014 4:08 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:50 AM
Points: 13,255, Visits: 11,036
You can design aggregations with XMLA, but I believe the designer will be more straight forward.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1549973
Posted Thursday, March 20, 2014 8:32 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 28, 2014 7:12 PM
Points: 2,148, Visits: 487
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.
Post #1553048
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse