SubsetCreate by MDX
Posted: Thu Apr 09, 2020 3:49 pm
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?
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?