Hi experts, is there a way for TI Process to create permanent Subset using MDX expression so it is dynamic.
I want the MDX to be stored with Subset too so that elements are dynamic.
Thank you
Is there a way for TI Process to create Subset using MDX?
-
- Posts: 88
- Joined: Mon Oct 24, 2016 1:21 pm
- OLAP Product: TM1
- Version: TM1 Perspectives 10
- Excel Version: Excel 2016
-
- MVP
- Posts: 1815
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: Is there a way for TI Process to create Subset using MDX?
Hi Ashleigh,
There are 2 functions that can do this for you:
SubsetCreateByMdx - can be used to create a new MDX subset.
OR
SubsetMdxSet - to add an MDX expression to an already existing subset.
Thanks,
Declan
There are 2 functions that can do this for you:
SubsetCreateByMdx - can be used to create a new MDX subset.
OR
SubsetMdxSet - to add an MDX expression to an already existing subset.
Thanks,
Declan
Declan Rodger
-
- Posts: 88
- Joined: Mon Oct 24, 2016 1:21 pm
- OLAP Product: TM1
- Version: TM1 Perspectives 10
- Excel Version: Excel 2016
Re: Is there a way for TI Process to create Subset using MDX?
Perfect! thank you! thank you!