Can you create text based calculated members in SSAS

user9913710 0
Viewed 16

Is is possible to have a calculated member that shows text instead of numerical values.For instance, classifying customers by the product they bought into Platinum, gold, silver and bronze.
enter image description here

Is it possible to aggregate the data and show it in the cube in this way?

cube olap-cube mdx ssas
1 Answers

Since you have a Multidimensional cube you write the calculated measures in MDX. You can use the Case function to build a calculation like this which returns text:

CREATE MEMBER CURRENTCUBE.[Measures].[Classification]
AS
Case
 When [Measures].[Volume] >= 1  And [Measures].[Volume] < 6 Then "Bronze"
 When [Measures].[Volume] >= 6  And [Measures].[Volume] < 11 Then "Silver"
 When [Measures].[Volume] >= 11 And [Measures].[Volume] <= 15 Then "Gold"
 When [Measures].[Volume] >  15 Then "Platinum"
End;
GregGalloway0
Related