Tag Info

New answers tagged


Try WITH Member [Age Band] Instead of WITH set[Age Band] Since you are doing a calculation based on the [Measures].[Age] Try the following and see if you can work with WITH MEMBER with member [Age Band] AS IIF([Measures].[Age]<26,"0-26",IIF([Measures].[Age]<51,"26-51","Over 50")) SELECT {[Age Band] } DIMENSION PROPERTIES ...


I highly suggest that you partition your cube. Then the server can parallelize the processing of the fact table, which likely will give you the biggest performance gain.

Top 50 recent answers are included