Unique identity to identify elements in TM1 subsetEditor

[kavitha2002]

Hello Everyone,

we have our own web application in which we have reports, views etc. In addition to that we also have subset editor almost similar to TM1 subsetEditor where user can pick the elements.

Having huge number of elements in dimension/subset there is a performance issue in fetching the data from MDX, and loading data in our application subsetEditor, in order to fix the problem, I had fetch first 50 elements and then 50 elements on scrolling and so on.

At one point the idea breaks because of the duplication of elements in dimension / subset., when user collapse/expand the element (for example: First element is Consolidated has 200 elements under that, am loading first 50 elements then user collapse) I could not able to find element exactly in TM1 subseteditor which element user collapsed because of duplication. I am using DRILLUPMEMBER() and TM1DRILLDOWNMEMBER for collapse/expand respectively when I pass the element it collapse/expand all the matching element.

sample.png (12.02 KiB) Viewed 2702 times

Question here is how can i find the exact element in case of duplication and Is there any index/numbering to identify the element uniquely in TI process.

Thanks buddies for your time.

--Please ignore if this is not part of this forum ---

[David Usherwood]

Elements are unique in a dimension (unless you are brave enough to use the unfinished named hierarchy functionality, in which case they are unique in a hierarchy) - so DIMIX gives you the index of the element.
I suggest that a clean up/deduplication of your subset would make life easier for your users. The Hierarchy Sort in the standard subset editor deduplicates.