Is there a way for TI Process to create Subset using MDX?

Post Reply
Ashleigh W
Posts: 88
Joined: Mon Oct 24, 2016 1:21 pm
OLAP Product: TM1
Version: TM1 Perspectives 10
Excel Version: Excel 2016

Is there a way for TI Process to create Subset using MDX?

Post by Ashleigh W »

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
declanr
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?

Post by declanr »

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
Declan Rodger
Ashleigh W
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?

Post by Ashleigh W »

Perfect! thank you! thank you!
Post Reply