How to restrict MDX to calculate only at level 0 and not TOP level
Summary
How to restrict MDX to calculate only at level 0 and not TOP levelContent
Hello All
I am facing an issue whicle creating a MDX script. I have written an MDX for one of the account members , for e.g.Mem1
MDX on MEM1.
CASE
When IsLevel([Period].currentmember,0) Then /* I tried using Islevel and ISLEAF functions */
[Mem2]*[Mem3]
ELSE
SUM([Period].currentmember.children,[Mem1])
END
for the above script when I look data for Mem1 at level 0 for an other dimension (for e.g DIm1) , it is doing the math correctly , but when I look at any of the parent levels for other dimension it is not showing me a sum of all its lev 0 members for Mem1 instead its doing the math as per above script for members at top level across other dimension.
0