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 *** |