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!
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...