I have what appears to be a bug in SSAS 2005 and 2008.
Optimization level is 0% when we add more than a certain number of dimensions to the cube.
I have a cube with 49 dimensions – some with multiple attributes and 22 measures in 1 measure group.
We can add 36 dims with no problem and the aggregations –via the wizard – work fine.
When we add the 37<sup>th</sup>, we get 0%. If we remove a random dimension it remains at zero, but if we remove the last one added it begins to work again.
It does not seem to matter which dimensions are added or excluded, the number is consistent at 36 dimensions max. (I assume this number would change depending on the complexity
of the cube)
Single fact table (view) and dimensions are all views as well.
I have seen other threads noting this situation, but none with a resolution, and none that have seen something with a specific threshold.
View Complete Post