Look at using DSO/XML and changing the underlying XML file that it
generates.
http://www.microsoft.com/downloads/d...DisplayLang=en
i.e export from one cube -- edit the XML file -- import it back into the
other cube.
As the XML is just a text string it is easy to parse and manipulate via a
program you have the requrement. Also the DSO/XML utility has a command line
version so you can easily script it..
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"MattFloyd" <MattFloyd (AT) discussions (DOT) microsoft.com> wrote
Quote:
I have built some calculated members that are measures in one cube. I am
now
building a separate cube. Is there any way to export the calculated
members
or share them so I don't have to recreate them in the new cube? |