Hi,

I have a cube showing number of customers allocated to salesreps. For the
time dimension, I would like the members in each level to show the value of
their last child - eg, the total for year 1997 should show the number of
customers in Quarter 4 (which should show the number of customers for
December).

I created custom rollups for the Year and Quarter levels which look like
this:

[Time].CurrentMember.LastChild

This worked fine while there was only 1 hierarchy in the time dimension.
However, after creating new hierarchies only the last members of each level
contain any data. Does anybody have any idea why this is happening? I must
be missing something obvious, but I can't think what it might be.

Thanks,

Peter

Hi

Not sure to see where your exact problem is, but one you start using
multiple hierarchies in a cube you will only see values at the intersection
of related members from all your hierarchies, or at the All level.
You can circumvent this by building MDX expressions that typically use the
LinkMember() function to display values independant from the current
selection on one particular hierarchy.
Just one other thing: I guess you must be referencing [Time.<Hierarchy>] in
your custom rollup formula, not just [Time]?

HTH

Olivier.

"Peter Kenyon" <p.kenyon.no.spam (AT) paradise (DOT) net.nz> wrote