[Mondrian] slicer vs filter.

Ati Rosselet ati.rosselet at gmail.com
Sat Mar 5 14:37:54 EST 2011


Hi,
I have a calculated Rollup member among my Measures.

I also have a Profitcenter dimension with format [Profitcenter][division][dept]
e.g. [PC][BU1][H1001] and [H1002]..etc

And I'm getting some odd results  with filter/slicers
when I use this, everything is fine
   where Crossjoin({[Measures].[TimeRollup]}, {[ProfitCenter].[BU1]})
same for this:
   where Crossjoin({[Measures].[TimeRollup]}, {[ProfitCenter].[BU1].[H1001]})

but as soon as I try to combine 2 items anywhere, ie
   where Crossjoin({[Measures].[TimeRollup]}, {[ProfitCenter].[BU1],
[ProfitCenter].[BU2]}
or
   where Crossjoin({[Measures].[TimeRollup]},
{[ProfitCenter].[BU1].[H1001], [ProfitCenter].[BU1].[H1002]})

everything goes haywire and the values just go up like a logarithmic chart...

If I move the measure to COLUMNS  - ie.Crossjoin ({......
[Measures].[TimeRollup]}) ON COLUMNS

the numbers are back to being fine.  Why does this not work as
selections for a filter?  Anyone experienced this or have an idea -
maybe a newbie schema problem or something? :(
Thanks
Ati



More information about the Mondrian mailing list