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
_______________________________________________
Mondrian mailing list
Mondrian (AT) pentaho (DOT) org
http://lists.pentaho.org/mailman/listinfo/mondrian