SubsetCreate by MDX

Post Reply
mnasra
Posts: 136
Joined: Tue Aug 10, 2010 5:40 pm
OLAP Product: Planning Analytics
Version: 2.0
Excel Version: EXCEL 2013

SubsetCreate by MDX

Post by mnasra »

Hi expert.
I created a subset in a TI process by mdx all recursive. It works beautifully. And I used it in views.

I need to update it regularly.
So, I had to write a subset destroy just before the subsetcreate in the TI.
It does not want to destroy because it is used in a view.

What is the solution? why am I creating a subset if I cannot use it in a view.
PS: I tried the subsetdelete all elements- It wont work, because it is a subsetCREATE.

what am I missing?
Thanks
Micheline
David Usherwood
Site Admin
Posts: 1458
Joined: Wed May 28, 2008 9:09 am

Re: SubsetCreate by MDX

Post by David Usherwood »

Look at SubsetMDXSet.
mnasra
Posts: 136
Joined: Tue Aug 10, 2010 5:40 pm
OLAP Product: Planning Analytics
Version: 2.0
Excel Version: EXCEL 2013

Re: SubsetCreate by MDX

Post by mnasra »

SOLVED! Thank you so much. I had never seen the subsetMdxSet.
Stay safe.
Thanks
Micheline
Post Reply