Level 0 Members in MDX (equivalent of @Relative)
Summary:
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...