Very briefly, my goal is to incrementally process the fact data for my SSAS 2005 cube, without losing aggregations.
For that purpose, I have defined all attribute relationships as rigid (I don't really expect any of the relations to change) because I hear that flexible aggregations get dumped during incremental processing. BIDS Helper indeed confirms that all of my aggregations
Then I proces the cube, either via the SSMS GUI using the "Process Incremental" option, or with an XMLA command using type "ProcessAdd". The outcome is the same, no matter which method I use.
Then I check the status of my aggregations. I do so first by sending a DISCOVER_PARTITION_STAT Discover XMLA query (http://geekswithblogs.net/darrengosbell/archive/2008/12/02/ssas-are-my-aggregations-processed.aspx), and, as a double check, by sending a
query to the cube from which I know it normally uses an aggregation and checking in the profiler whether the aggregation is really used.
The result is always the same: The aggregations are lost! The DISCOVER_PARTITION_STAT query informs me that all aggregations have size = 0. Note, that after a ProcessFull, all aggregations are there (with size > 0) and work as expected, so the problem
only occurs after incremental processing. Also for the problem to occur it is enough to incrementally process the cube, the dimensions are lef
View Complete Post