Page 1 of 1

updating With MDX of Exisitng Subset Which has no MDX

Posted: Mon Mar 03, 2014 5:52 am
by Firefly007
Hello Dear Experts !

I need your suggestions and advise to solve this issue.

I have currently a Subset called Default in Dimension Company. which is used in Views as well. I need to create a MDX to update the Default subset to top level consolidation, which I am able to do through Subset Editor by updating the MDX .

Now..

I would like to do the same update(Updating MDX ) using TI without dropping the Subsets is it possible to do this action?


Please advise....

Thanks

Re: updating With MDX of Exisitng Subset Which has no MDX

Posted: Mon Mar 03, 2014 8:17 am
by rmackenzie
Firefly007 wrote:I would like to do the same update(Updating MDX ) using TI without dropping the Subsets is it possible to do this action?
No, there's no function to update the existing MDX attached to the subset - you've got to use SubsetDestroy first and then reset the MDX.