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

Mutually Exclusive Dimensions - using same measure

Started by blackhawk, 18 Nov 2008 01:13:05 PM

Previous topic - Next topic

blackhawk

here's the deal...
i have a HR Forecast cube that contains a Employee Dim(existing employees) and an Initiatives Dim(future employees) that share 1 measure....FTE.  these dimensions are mutally exclusive; therefore, i want to only see the FTE total for each when used.
For Example, the 2009 year-end total for EMP = 100; INIT=25; when i use either dimension i'm incorrectly getting the 125 total.  what i want is..when i drag-over the EMP dim for FTE = 100; INIT dim for FTE = 25.

is this possible?

fyi...
-1  i've tried to suppress the 'blank' member, however, the total (125) still shows.
-2  i cannot split into 2 different measures (EMP FTE AND INIT FTE)

does transformer 'force' totals to be consistent amongst dimensions?

thanks for your help!

nonooo

you can make two dimensions:

one "actual":
first level = actual + future_tohide
other levels...

one "future":
first level = actual_tohide + future
other levels...

and then you create custom views for this two dimensions. the problem is that you will have the 125 total if you do not use one of these two dimensions...