How to check Ancestor/Parent of shared member in MDX
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!
0