Dimension

[pabcig]

I ask the question again more clear!

I need to have the same calculeted member for diferentes dimensions.. can i do one calculated member only, that include the diferent dimensions.

Thanks
Paul

[Island1]

If I understand the question, the answer is "of course you can!" Give me an example - within the Analysis services samples, if not too inconvenient - and I'll try to give back a useful answer.

BTW, I noted that you got back to the group with a solution you found after asking a question earlier - this is super appreciated, because if we all did this, anyone with a problem could not only find their issue within a question, but could activate a solution based upon someone else's experience.

Good job, I must say... you are a valuable member of the community.

B*

[pabcig]

I tried something, but i don´t know if it is ok.

To ask for a dimension a put:

Iif([Dimension_1].CurrentMember.Level.Ordinal >= 0), F, Iif([Dimension_2].CurrentMember.Level.Ordinal >= 0), F, 0))

Where is the "F" i put the pareto calc for each dimension. For the first dimension it works properly, but for the other dimensions doesn´t work. Is something wrong.. is another way?

Thank´s
Pablo