Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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 check Ancestor/Parent of shared member in MDX

edited Jan 16, 2020 6:52AM in Planning 4 comments

Content

Hi gurus,

In the ASO cube, I have the main hierarchy and alternate hierarchy like below.

Main hierarchy:

North America

        Ent 1

        Ent 2

       ..............

Alternate hierarchy:

North America Reporting

      Ent 1(shared)

      ...................

 

I have a request in a member formula with MDX to check if the current entity is Ancestor/Parent of a specific entity(e.g. Ent 1) then do some calc. Using IsAncestor() or Is(xxxxxx.Parent , xxxxx) it only work for North America, but not working for North America Reporting.

Is there any way to get around this?

Thanks!

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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