Does anyone have any recommendations on how to handle While loops with tm1Ui promise calls? I am trying to work my way up our hierarchy until I find an attribute match.
So check and try it out first on your subset editor to verify that the above gives what you are looking for already. If there are more, then you can just adjust the mdx filter accordingly.
I have been going down the MDX path after I posted that and our hierarchy is giving me issues since we have multiple parents.
The ideal way of using MDX for me would be to do something like Ascendants([ProfitCenter].[CustomerName]) then I can just loop through the results and pull out the elements that have the Level attribute values I want. My problem is that the function is bringing back the wrong parents. So I am trying to figure out the way to get the right ones.
How do you visually determine then which one is the correct parent if they all have the same Level attribute value? Or is there a specific attribute value that distinguishes them?
Another potential way without going through loops with the promise calls, is to execute the MDX with Ascendants, and then just to loop through the results instead. Are there lots of elements?
But still, looping through all of the parents, it still needs a specific rule or condition to find out which parent are you looking for.
Could you elaborate more on the parent element you are trying to search for?
You can exclude more than one by nesting EXCEPT. Are the consolidations to be excluded known? Because if they are, you should be able to theoretically combine this with the other TM1* mdx functions to get and to filter the elements.