Create case statement in SSAS OLAP design
Posted on 2008-10-10
I am trying to build a calculated member for an OLAP cube using Micro Soft Analysis Services. The attributes hold a boolean value. Basically I want to create a case statement which looks at the boolean value in 5 attributes and if the value is true in Attribute1then 'descriptor01', if the value is true in Attribute2 then 'descriptor02' ... to Attribute5. The aggregation at the various descriptor levels will always be more than the count of records as a record can have a true boolean value in more than one of the 5 dimensions.