I'm tuning up aggregations, The wizard doesn't create all the necessary ones. Lets say I've a time Dim and attribute relationships defined for the hierarchy from Year - Month - day. I've partitioned the cube by year. [2011 partition] has 26 aggregations
built, The advanced view of Aggregation shows that it has built 26 aggregation for (Time intelligence) attribute but non on Year, Month or day attribute.
I cleared the cache and ran the profiler and drop the Time dimension hierarchy in excel 2007and see Query Begin and Query End events and I don't see any events for 'Get data from aggregations' and duration for query was 8000 ms.
What should I do next?
Since I have 26 aggregations built for that partition,
How many aggregations do I need to add for the Year Attribute? Same,how many aggregations do I need to add for Month .......?
I see when I put 4 aggregations for the Year, its been picked up by 'Get data from aggregations' event. Do I need to start from 1, 2,3...and so on until it gets picked? (my question is how much is too 'less' and too 'much'? how can I determine this?)
I would appreciate anyone who can help me understand this..
View Complete Post