I have a situation where a custom member in a dimension
sometimes needs to be added in another dim's hierarchy,
and sometimes subtracted.

How do I handle this ?

Thanks

This is the typical multiple parents situation that has been discussed in
previous thread.
- Create duplicate members with the same name but different IDs..
- For the second instance of the member, create a custom member fromula that
point to the initial member (since it is the one that is linked to the
transaction in the fact table)
- Now each instance can report to different parent in the same or in
different hierarchies and can each have different unary operator....

Thierry

This posting is provided "AS IS" with no warranties, and confers no rights.
"Mark" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Thanks for the reply.

In your solution, will end users see two members with the
same name in the hierarchy ?

Can I handle this in the custom member formula, or do
those formulas get calculated and stored at the leaf
level, then aggregated according to the unaries of the
other dims ?

You will see two members with the same name but different keys. Also notice
that they will show the same numbers.
These formula get calculated on the fly at query time... They are going to
be instantaneous anyway since they are just pointers to another members. The
value for each member gets rolledup to their respective parents with their
respective Unary operators..

Thierry

This posting is provided "AS IS" with no warranties, and confers no rights.

"Mark" <anonymous (AT) discussions (DOT) microsoft.com> wrote