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

MDX

edited Jul 21, 2020 4:49PM in Planning 1 comment

Summary

Summarize the select statement so each geography does not need to be individually listed

Content

Hi,

The below MDX code works as expected for the 3 geographies. However, I have 72 level zero geographies in EMEA.  I do not want to call out each geography separately.  Does anyone know how to streamline to obtain level zero descendants of EMEA and exclude G305 which is treated separately?  I do have additional rollups in EMEA as well such as Northern Europe, etc.  Even if I can call out the level zero members of the parents under EMEA that would be helpful.  I did try IANCESTORS but that result gave me the wrong basis for the calculation.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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