Analysis Services 2005 Deployment Wizard

I am working with SQL server 2005 analysis and reporting services. I am

instructed to create a cube for a database using analysis services and
then replicate it so as to produce reports online by reporting services

when requested by clients. I am able to create the cube and also deploy

the report made, in HTTP separately. But the following doubts arise
during the Cube deployment:

The Cube was created as per the requirements by my team lead. Then I
used the deployment wizard in the analysis services 2005 to convert it
into XML script. Using the SQL Management Studio I opened it as
Analysis Server scripts and used the local host as the system in the
connections windows then loaded the XML script into the Queries window
as a XMLA query and executed it. What has to be done after this in
order to use it as a production server?

Once the production server is setup and the connection is made with the

staging server, How can we set the timings to when the updating of the
production server has to be set in terms of hours, days or weeks?

Hoping these doubts would be clarified as early as possible.

Take a look at the Synchronization functionality in Analysis Services. It allows you to synchronize on database to another using single command.

In your case I can imagine, you having updates done to a single master server, and then running sycnhronization commands against multiple servers telling them to synchronize the changes happend on the master.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.