Not Seeing Deploy MDX Script..

Topics: Resolved
May 14, 2008 at 5:47 PM
Hi

I just installed the BIDS Helper. I am able to edit aggregations.

However, I am not seeing some features including Deploy MDX Script when I right click on the cube in VS.

What am I missing?

thanks
Murthy
May 14, 2008 at 6:02 PM
I just read that this feature is not available when working with the cube online.

I have a large database and I am working in online mode so that explains it.

Currently if I make a change to the MDX script/calc member and try to save it, it takes a looong time. I was hoping this feature might save some time.

I appreciate if you could suggest an alternative which may save some time.

thanks
Murthy
Coordinator
May 18, 2008 at 12:50 PM
You might find that working in offline mode and using the Deploy MDX script feature may be faster. It sends the absolute minimum XMLA required. I have never traced the online mode to see what it is doing, but I suspect that a save operation might be sending the Alter XMLA for the entire cube.