dbTalk Databases Forums  

Share measures across cubes

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Share measures across cubes in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
MattFloyd
 
Posts: n/a

Default Share measures across cubes - 11-17-2004 , 05:38 PM






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?

Reply With Quote
  #2  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: Share measures across cubes - 11-17-2004 , 05:44 PM






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?



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.