I created a cube and I want to give it to several persons for the installation on their SQL Server 2005. Is it possible to create something like an installation package (similar to the deployment manifest in SSIS)?
Thanks for any help!
No, but you can script out the database as an XMLA script and then execute it on another server. To create the script, use SQL Management Studio and right-click on the Analysis Services object. One of the options should be Script \ Create.
There are several ways to execute the XMLA script on the remote server. One way would be to enter it as a SQL Agent Job. One of the command types is Analysis Services DDL script. Another way would be to exeute it via an SSIS package. In fact you could put the XMLA script right in the SSIS package and then deploy the package.
One of the features which unfortunately was a command-line utility to execute a XMLA script. We are trying to get it released in one of the web release of the Samples.msi later next year.
Hope that helps.
_-_-_ Dave|||That's exactly what I need. Thanks alot!
