What's new in Customer Journeys?

Connect and learn more! ×
Level 0 Members in MDX (equivalent of @Relative) — Cloud Customer Connect
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

Level 0 Members in MDX (equivalent of @Relative)

Accepted answer


Dear All,

I look for an equivalent of @Relative in MDX. My search only let me find Descendants and Level functions. Although for level function the documentation describes it as retrieving the number value # of the specified member, it seems that it can also be used to retrieve all Level0 members. In my case, all Level0 Members of a specific parent (Total_CostCenter) is needed.

So the MDX Descendant Function delivered the needed Level0 Members based on the specified parent. However, it has a strong disadvantage as the LEAVE value for Desc_flags is only possible when I enter a layer number in which level0 members are derived from. I would prefer a function like @relative so independent of specified layers all level 0 members from a parent are retrieved. This way, I end up with a higher layer number and in case of new layers I might need to correct all scripts...

Howdy, Stranger!

Log In

To view full details, sign in.


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