combination of attributes problem


  • Hello,

    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 ?


    Friday, June 28, 2013 8:20 AM