Import Calc Mbrs from Another Server

[cwsstins]

I'd like to find a way to import calculated members from a separate instance of Analysis Services on a different server.

I'm working with a virtual cube and right now, if I need to add a new calculated member, I add it to our test environment first, then if all works well (within the app that runs off of AS), I manually perform all those steps to create the new calc mbr again in production.

Is there a way to do it all in test, then once it's tested and confirmed, to import all the work into the production environment?

 

[MDXer]

DSO in VB VB.NET or C# is what you need to use. I used to have an app I built to do this. I'll see if I can find it. I have one that will script them out to a text file just lost the one to write them to the new cube. But I'll look.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck