dbTalk Databases Forums  

Process Update Dimension will drop aggregation?

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


Discuss Process Update Dimension will drop aggregation? in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
sqlprobs@gmail.com
 
Posts: n/a

Default Process Update Dimension will drop aggregation? - 11-08-2006 , 07:53 AM






According to BOL

Forces a re-read of data and an update of dimension attributes.
Flexible aggregations and indexes on related partitions will be
dropped. For example, this processing option can add new members to a
dimension and force a complete re-read of the data to update object
attributes. This processing option is supported for dimensions and
mining models.


Means if I update dimension then will it drop index and aggregation?
If aggregation is dropped then will it effect on performance of cube
or not?
How can I regenerate the aggregation ?


Reply With Quote
  #2  
Old   
Darren Gosbell
 
Posts: n/a

Default Re: Process Update Dimension will drop aggregation? - 11-08-2006 , 09:13 PM






When you do a process update on a dimension with flexible relationships
the aggregations should be dropped AND recomputed automatically. So
basically what BOL is telling you is that Process Update may take some
time if AS has to re-calc all the aggregations in addition to updating
the dimension.

However, if you have configured your measure groups to use the
LazyAggregations processing mode there will be some lag time between the
dimension being upated and the aggregations being re-processed where the
cube may respond to queries more slowly than usual.

You can manually re-process the aggregations if you need to by choosing
the Process Index option when you process the cube. This will not
re-read any fact data, but will use the fact data it already has to
rebuild all the indexes and aggregations for the cube. But this should
not be necessary when you Process Update a dimension as AS handles it
automatically.

--
Regards
Darren Gosbell [MVP]
Blog: http://geekswithblogs.net/darrengosbell

*** Sent via Developersdex http://www.developersdex.com ***

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.