updating With MDX of Exisitng Subset Which has no MDX

Post Reply
Firefly007
Posts: 25
Joined: Tue Feb 26, 2013 12:51 am
OLAP Product: PA,PAW
Version: PA 2.0, PAW(2059)
Excel Version: Excel 2010

updating With MDX of Exisitng Subset Which has no MDX

Post 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
rmackenzie
MVP
Posts: 733
Joined: Wed May 14, 2008 11:06 pm

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

Post 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.
Robin Mackenzie
Post Reply