We have a customer dimension with around 10 attributes that starts with Has.. or Is.. Examples are IsMale, IsHouseOwner, IsMarried, HasChildren. Answers will be Yes No and Unknown. Now if the users start query-ing it in excel and they use those attribute
as filters everything works fine. But the moment they move those attributes to the rowlabels the cube get slower and slower.
I understand that the cubes tries to make some kind of combinations. For example the first attribute has only 3 combinations, the 2nd one with the first gives 9 combinations, the 3 27 and so on. Now I thnk the possible combinations would be 3 ^ 10 which
is 59.049 combinations. Of course if you take the order of the attributes into consideration you get a 10! which is 3.628.800
How can I speed up the response time of the cube ?
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.