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
[Time].CurrentMember), [Measures].[amount])
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],

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?
Mondrian mailing list
Mondrian (AT) pentaho (DOT) org