TM1 Forum

Dear all,

I am fairly new to TM1 and I would like to seek your kindly advise on the following problem



Let say I have a Dimension call "Trade ID" and has a list of element attributes inside, namely internal reference, external reference and so on and this Dimension is use as a element across different cubes and result. . What I am trying to achive is that, I would like to find all trade ID that have a internal reference element attribute "X" (might be more than 1) , retrieve all its trade ID (Maybe through DimensionElementPrincipalName ?) Is this possible? If not, in what way i should think and solve this problem?

If you're just using subset editor, you can filter by attributes. You can also create a dynamic subset with mdx that does the same thing. A dynamic subset can then be referenced in TI processes or saved cube views and you wouldn't need to worry about adding new elements to the list since it'd be dynamic.