Page 1 of 1

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

Posted: Thu Jul 22, 2021 1:41 pm
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

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

Posted: Thu Jul 22, 2021 1:45 pm
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

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

Posted: Thu Jul 22, 2021 2:09 pm
by Ashleigh W
Perfect! thank you! thank you!