I have two attributes (A and B) which have the exact same set of members.
I have a measure giving me a value for the relationship (A,B).
In a calculated measure, I would like to automatically calculate the value for (B,A) (which is not the same as (A,B)).
I was thinking of doing the following in the calculated measure:
1. Get the selected members of attribute A.
2. Perform SetToStr on the set of selected members.
3. Replace the name of attribute A by the name of attribute B.
4. Perform StrToMember.
5. Do steps 1-4 for attribute B.
6. Retrieve the value.
Unfortunately I have no idea how to perform a string replacement with MDX.
Am I missing something?
View Complete Post