You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to restrict MDX to calculate only at level 0 and not TOP level

Received Response
12
Views
1
Comments
edited Aug 2, 2018 2:36AM in Essbase 1 comment

Summary

How to restrict MDX to calculate only at level 0 and not TOP level

Content

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!