We are routinely getting requests from users to add new dimensions or
measures into cubes or add calculated members.

We develop and test the changes in our Development server and manually
are redoing all these changes in Production server again.

Is there a scripting option available in Analysis Services like in the
SQL Server DB where we just capture the tables, indexes or stored
procedures in scripts and apply the script in production server to move
the new incremental changes from Development to Production.

I could not find much help on scripting cubes, calculated members or
dimensions.

Please help

Thanks
Karen

look at the dsoxml tool (microsoft web site)
this tool create an xml document based on your choices then you can apply it
on the destination server.

but... this tool has never work for me ;-)
because the destination server is always different from my local version and
the utility can't create the new dimensions & cubes due to these little
differences.


<karenmiddleol (AT) yahoo (DOT) com> wrote

what do you mean by different?

i usually just go in and change the server names in the .xml file.


"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote

There is an extensive discussion of this topic in the AS Operations Guide in
the section titled Release Management
http://www.microsoft.com/technet/pro.../anservog.mspx
--
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.


<karenmiddleol (AT) yahoo (DOT) com> wrote

in my case, if the data source name is different, or if 1 of the shared
dimensions used in a cube has been changed in the targeted server, then the
utility don't create the new cube because the current dimension is not the
same as expected.

its because we don't play with dev & prod servers but with dev & (deployed +
customized deployments)
so the target server is never the same as the dev. server.


"Jesse O" <jesperzz (AT) hotmail (DOT) com> wrote

karenmiddleol (AT) yahoo (DOT) com wrote:


Try to check out http://www.solgenia.com/usa/Solutions/Sheets
SheetAnalysisModeler.htm

You can download a trial demo.