Hw can the cube be modified after deployment?

Hi,

We used cube in our project.

And the project is released to production environment.

Now we need to modify the cube.

Can anyone have any idea what are the ways we can handle this?

Appreciate any suggestion.

Sachin!

If this is an SSAS2005 cube you will have a project in BI-Developer Studio? Open the project and make the changes and redeploy the script to the SSAS2005 server.

The other way is to reingeneer a deployed cube. BI-Dev Studio have a project for this as well: "Import Analysis Services 9 database". Once you have a new project you can start making changes.

HTH

Thomas Ivarsson

|||The third alternative is to connect online to the cube. In Visual Studio go to File -> Open -> Analysis Services Database, and you will end up making changes directly to the cube on the server without having to deploy the changes - just hitting Save will make the changes immediatelly.|||

But without a blueprint/copy of what you have done. You should always work with a project?

/Thomas Ivarsson

|||In online mode you still have a project - it's just online project - everything is on the server. It is ultimately up to the developer in which mode he wants to work. (BTW, in AS2000 the only available mode was online mode).|||

We have deployed product at many client locations.

Now we need to add few things to the cube

But it is not feasible to go and change manually at all locations and same time client may not want that.

We are looking after creating an update for the product.

Now the question is how to update cube? One option is delete existing cube and create again with new xmla script and process cube.

Can you please suggest any other way to do so?