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?
SubsetCreate by MDX
-
- Posts: 136
- Joined: Tue Aug 10, 2010 5:40 pm
- OLAP Product: Planning Analytics
- Version: 2.0
- Excel Version: EXCEL 2013
SubsetCreate by MDX
Thanks
Micheline
Micheline
-
- Site Admin
- Posts: 1458
- Joined: Wed May 28, 2008 9:09 am
Re: SubsetCreate by MDX
Look at SubsetMDXSet.
-
- 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
SOLVED! Thank you so much. I had never seen the subsetMdxSet.
Stay safe.
Stay safe.
Thanks
Micheline
Micheline