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?
Retrieve list of result
-
- Community Contributor
- Posts: 287
- Joined: Fri Feb 15, 2013 5:49 pm
- OLAP Product: TM1
- Version: PA 2.0.9.1
- Excel Version: 365
- Location: Minneapolis, USA
Re: Retrieve list of result
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.