If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cube Dimension creation- need help..

Started by gops210, 25 Feb 2008 05:00:15 AM

Previous topic - Next topic

gops210

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.

almeids

  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.