dbTalk Databases Forums  

Cube processing not working as I expect it.

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Cube processing not working as I expect it. in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
 
Posts: n/a

Default Cube processing not working as I expect it. - 04-03-2005 , 06:41 PM






I am doing incremental processing in analysis services
and our cube size is about 60 gig. We have partioned our
cubes into time base dimensions. They are 2000, 2001,
2002, 2003, 2004, 2005. We know that the aggretations
for 2001 through 2004 don't need to be aggregated anymore
and defined our slice to be 2005 for processing the cube
that way it doesn't reagregate all the other years that
are constant but it is still aggregating across all the
partitions. Anyway how do I circumvent this so it only
aggregates 2005 partition?

Thanks,
Tom


Reply With Quote
  #2  
Old   
OLAPMonkey
 
Posts: n/a

Default Re: Cube processing not working as I expect it. - 04-04-2005 , 11:47 AM






Each partition has it's own aggregation design. You can drop the
aggregates on your other partitions. Go into Analysis Manager...drill
down to the partitions in questions (2000-2004). Right click the
partitions and choose Design Aggregates. When you get to the screen
where you can choose a percentage...choose 0% and move on. That should
remove your aggregates from the design.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.