Hi All,
I have a cube in which i need to create a dimension X which should have a level,i need three categores A,B,C which should be calculated based on the
calculation ie..when <Measure1> >0 then A when <Measure2> >0 then B when <Measure3> >0 then C
i want all the three categories to be dispalyed in the single level.
Please help me on this.
The logic you've described is easy enough to implement...just create a calculated column in your fact (measure) query in your Transformer model using nested IF () THEN() ELSE () statements...but I'm not sure what sort of results you'll get basing the value on 3 different measures, unless there's an implicit relationship among them. If you're trying to allow for selection of positive values of any or all of the 3 measures without such a relationship, you'll need 3 dimensions each with a level/category based on the value of the appropriate single measure.