Hi all,
I'm having a strange problem with a rollup on a Time dimension

Sum(Ytd([Time].[Year].[Time].CurrentMember), [Measures].[amount])
or using
Sum(PeriodsToDate([Time].CurrentMember.Parent.Level,
[Time].CurrentMember), [Measures].[amount])
or...
I get exactly the same results (and strange ones at that).

Basically, if I have values for months jan-A, feb-B, mar-C, apr-D,
then I would expect to get (with the rollup)
jan :A , feb: A+B, mar: A+B+C...

but what I'm getting what appears to be
jan: A, feb: A+(A+B), mar: A+(A+B)+(A+B+C)...

which of course is a pretty exponential curve, but not what I need.

Weirdly enough, it seems to be linked to my where statement,
if I have
Crossjoin({[Measures].[YTD]}, {[ProfitCenter].[BU1].[H1001],
[ProfitCenter].[BU1].[H6001]})

then it does this, but if I only have 1 ProfitCenter or 1 item (e.g.
[BU1]), the results are normal.
The summing is also correct if I move the YTD measure out of the
filter and onto a an axis...

Has anyone encountered anything like this, or have a clue as to what
might be going on?
Thanks
Ati
_______________________________________________
Mondrian mailing list
Mondrian (AT) pentaho (DOT) org
http://lists.pentaho.org/mailman/listinfo/mondrian