dbTalk Databases Forums  

Scripting the OLAP database

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


Discuss Scripting the OLAP database in the microsoft.public.sqlserver.olap forum.



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

Default Scripting the OLAP database - 05-16-2005 , 05:28 AM






Hi Experts!

Every day, I backup my OLAP database using msmdarch utility. Additionally, I
would like to have script of my OLAP database for every day, eg
Sales_20050515, Sales_20050514 and so on.
Generaly, I'm using the "Meta Data Scripter" when creating the script
manualy. But is it possible to include the metada data scripter in everyday
job? ie I would like to run meta data scripter from command line. Does
anybody has some sample?

Another option - use dso / xml conversion utility. Is it possible to run
utility from command like for creating xlm?

Thank you

Ramunas Balukonis



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

Default Re: Scripting the OLAP database - 05-16-2005 , 02:00 PM






The metadata scripter is an Analysis Manager addin. It cannot be called from
the command line.
The DSO/XML utility has a command line interface.
--
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.

"Ramunas Balukonis" <ramblk2 (AT) hotmail (DOT) com> wrote

Quote:
Hi Experts!

Every day, I backup my OLAP database using msmdarch utility. Additionally,
I
would like to have script of my OLAP database for every day, eg
Sales_20050515, Sales_20050514 and so on.
Generaly, I'm using the "Meta Data Scripter" when creating the script
manualy. But is it possible to include the metada data scripter in
everyday
job? ie I would like to run meta data scripter from command line. Does
anybody has some sample?

Another option - use dso / xml conversion utility. Is it possible to run
utility from command like for creating xlm?

Thank you

Ramunas Balukonis





Reply With Quote
  #3  
Old   
Ramunas Balukonis
 
Posts: n/a

Default Re: Scripting the OLAP database - 05-18-2005 , 12:06 AM



Dave,
I see, that DsoXmlConsoleClient.exe has only params to run XML->DSO mode. I
need to create xml file from dso. Thank you.

USAGE:
Microsoft.BIPractices.DsoXmlConsoleClient
/file:[path]filename
[/serverNamelapServerName]
[/removeEmptyDimensions:remove]
[/confirmOperation:confirm]

WHERE:
[path]filename location of XML file to convert to DSO
NOTE: must be a valid file path.
This switch IS required.




"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> wrote

Quote:
The metadata scripter is an Analysis Manager addin. It cannot be called
from
the command line.
The DSO/XML utility has a command line interface.
--
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.

"Ramunas Balukonis" <ramblk2 (AT) hotmail (DOT) com> wrote in message
news:1116239312.122918 (AT) loger (DOT) vpmarket.int...
Hi Experts!

Every day, I backup my OLAP database using msmdarch utility.
Additionally,
I
would like to have script of my OLAP database for every day, eg
Sales_20050515, Sales_20050514 and so on.
Generaly, I'm using the "Meta Data Scripter" when creating the script
manualy. But is it possible to include the metada data scripter in
everyday
job? ie I would like to run meta data scripter from command line. Does
anybody has some sample?

Another option - use dso / xml conversion utility. Is it possible to run
utility from command like for creating xlm?

Thank you

Ramunas Balukonis







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.