dbTalk Databases Forums  

Calculated cells - where is MDX code stored?

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


Discuss Calculated cells - where is MDX code stored? in the microsoft.public.sqlserver.olap forum.



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

Default Calculated cells - where is MDX code stored? - 09-17-2004 , 06:07 AM






I'm hoping to 'cut & paste' calculated cell formulae from one cube to another
very similar cube, then edit as neccessary in the cube editor, but cannot
find where the original cube holds the formulae.
Any help gratefully received...

Reply With Quote
  #2  
Old   
Jéjé
 
Posts: n/a

Default Re: Calculated cells - where is MDX code stored? - 09-17-2004 , 07:47 PM






try the DSOXml tool
http://www.microsoft.com/downloads/d...displaylang=en

this tool can export into an XML file some definition and reapply these to
another cube.

"Richard Shields" <RichardShields (AT) discussions (DOT) microsoft.com> a écrit dans le
message de news: 9ED8C624-41AF-4C81-ABB8-D9135C5A8BC8...soft (DOT) com...
Quote:
I'm hoping to 'cut & paste' calculated cell formulae from one cube to
another
very similar cube, then edit as neccessary in the cube editor, but cannot
find where the original cube holds the formulae.
Any help gratefully received...



Reply With Quote
  #3  
Old   
Richard Shields
 
Posts: n/a

Default Re: Calculated cells - where is MDX code stored? - 09-20-2004 , 05:37 AM



Thanks Jéjé...
That did just what I wanted.

Regards

Richard


"Jéjé" wrote:

Quote:
try the DSOXml tool
http://www.microsoft.com/downloads/d...displaylang=en

this tool can export into an XML file some definition and reapply these to
another cube.

"Richard Shields" <RichardShields (AT) discussions (DOT) microsoft.com> a écrit dans le
message de news: 9ED8C624-41AF-4C81-ABB8-D9135C5A8BC8...soft (DOT) com...
I'm hoping to 'cut & paste' calculated cell formulae from one cube to
another
very similar cube, then edit as neccessary in the cube editor, but cannot
find where the original cube holds the formulae.
Any help gratefully received...




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.