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
updating With MDX of Exisitng Subset Which has no MDX
-
- Posts: 25
- Joined: Tue Feb 26, 2013 12:51 am
- OLAP Product: PA,PAW
- Version: PA 2.0, PAW(2059)
- Excel Version: Excel 2010
-
- MVP
- Posts: 733
- Joined: Wed May 14, 2008 11:06 pm
Re: updating With MDX of Exisitng Subset Which has no MDX
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.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?
Robin Mackenzie