I am currently working on a financial reporting project. We created a cube that contains general ledger data. At the begining of the development phase, I run the aggregation wizard and SSAS was able to create aggregations. Yesterday I retried to run the
wizard and to my surprise SSAS was not able to find any suitable aggregation. I searched on the internet to find out if someone experienced the same behavior and found the following link:
We have several defined hiearchies on the [Organization] dimension that can benefit from aggregations.
I looked at the design of the cube and could not find any reason that could explain the behavior of SSAS (not finding any aggreg.)
In the end I took the solution from the point where it was still able to create aggregations and started to redo all the modifications (one after the other) always running the aggregation wizard in-between. I was hoping that at some point aggregations would
not work anymore and that I could identify which modification is guilty.
Strangely I was able to perform all the modifications and the wizard was still able to build aggregations.
I the scripted the corrupt database and the non-corrupt database and compared them (using a text comparison tool). I was not able to find any significant difference.
Did someone exprience similar problems? :-) I kn
View Complete Post