TM1 Forum

Hi,

I've got a question:

Is TM1 able to deal with "shared Members"? It means to add an Element at different positions of a dimension but to calculate it only once when consolidating into higher hierarchies.

Greetings
Alex

CoN73mP7 wrote: I've got a question:
Is TM1 able to deal with "shared Members"? It means to add an Element at different positions of a dimension but to calculate it only once when consolidating into higher hierarchies.

I'm not completely sure what you're getting at, but:
- You can only add an element once in a dimension. You can't have the element itself appearing in different locations, though obviously if you add it to multiple consolidations, and expand each of those consolidations, then you'll see it appear under each consolidation that it's a member of.
- You can add the element into as many or as few hierarchies as you want. If the hierarchies are separate from each other, then it'll only be counted once in each hierarchy.
- On the other hand if you add it to two different consolidations, and both of those consolidations roll up to another higher level consolidation, then the element will be counted twice when you calculate the top level consolidation. The usual way around that is to add it to the top level consolidation as well, but with a weight of -1. (That is, subtract its value from the top level consolidation to remove the double counting.) I'd avoid that approach if possible, though; it's potentially very confusing.

The usual way around that is to add it to the top level consolidation as well, but with a weight of -1

Thats exactly what we are doing at the moment with Cognos 8. And you're right, it gets very confusing! Thats why I was looking into that problem. I'm researching, if TM1 has a better way to do it, but obviousy it has not.

Nevertheless thanks for your answer

Alex