Hi,
We have a few cubes designed using the Analysis Manager. Is there a
way to generate a script, in any language, that will create cubes with
exactly the same structure as our cubes? Are there tools available
that do this?

Thanks
Yash

"Yash" <yashgt (AT) yahoo (DOT) com> wrote

There are few Metadata scripters available (both free and commercial)

http://msdn.microsoft.com/library/de...ml/sql01f1.asp -
Microsoft SQL Server Resource Kit
http://www.winsight.fr/DOWNLOAD/W00DLD001U.asp#8 - Winsight XML OLAP
meta-data import/export utility
http://www.mosaicinteractive.com/mit...ProductID=0103 -
DSO/XML conversion by MosaicInteractive - This utility round-trip converts
DSO metadata to/from standalone XML files. Specifically, it allows for DSO
metadata (dimension/cube structures, etc.) to be converted into XML and
allows for the resulting XML to be converted back into DSO structures. It
describes the entire DSO object model and allows you to script objects for
add, remove or replace (similar to the SQL 2000 QA). This tool allows you as
a developer to distribute OLAP/Analysis Services solutions in such a way
that a person can completely install the solution (including DTS) through a
wizard in minutes even if they know nothing at all about OLAP/Analysis
Services. It even provides a mechanism for instant documentation of your
OLAP/Analysis Services solution.
http://groups.msn.com/MicrosoftOLAPS...pgmarket=en-us -
OLAP Script Generator by ramkoth_p - This tool is intended to be used for
scripting OLAP Database definitions to an XML based script file and creating
a new OLAP database from the script.

--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================