Basically we have a level attribute that tells us when an element is a sector or division of a customer.
So for example,
---- Division A Name
-------- Sector A Name
------------ Some parent Element
----------------- Customer Name
each of these elements has a “Level” attribute that tells me if they are a sector, division, customer, etc.
In my scenario, I have the customer name already, I am trying figure out that customers Sector and Division elements.
My issue is that customer name is also in a different consolidation
---- custom name
------- Customer name
The ascendants MDX call is bringing back the customs its in and not the one I really want…
Even the tm1Ui function with the request to return parents, only returns one of the two, and its the wrong one. =(