I have one question about Advanced view of Aggregation tab. I have aggregation from A0 to A11. How can I identify which check box I have to check for each dimension attribute? Please see below snap.
I have one question about Advanced view of Aggregation tab. I have aggregation from A0 to A11. How can I identify which check box I have to check for each dimension attribute? Please see below snap.Please help me to clear this
- Edited by NikkRED Sunday, May 18, 2014 4:57 PM
Thank you for your question.
I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated.
Thank you for your understanding and support.
TechNet Community Support
There're lots of factors to design aggregation for SSAS cube. A good aggregation design actually will depend on your cube design, the underlying data(eg. How many records in a dimension table) and business query requirement(eg. what kinds of data will be most frequently accessed by applications or reports).
Usually we should use Aggregation Design wizard or Usage based optimization to design aggregations for cube. One scenario to manually design aggregations is to optimize one specified MDX. Here is a tool in the codeplex for your reference.
For one specified MDX, we can run it with cold cache, capture the profiler trace and check Query Subcube event with large duration. Then we can copy the TextData and use it to identity the required aggregation with Aggregation Manager tool.
Thanks for reply..
From the above screen shot, we can see 11 aggregations are created.so, I just want to know which check box I need to select? The dimension you are seeing is Dim_Hierarchy contains Hid,Hname,..etc .Do I need to select all check boxes for all dimension attribute or select only selected check boxes?