deploying cube w/o database dependencies

Hi,

I have been asked to find a way to deploy a SQL 2005 cube with no dependencies on the relational database. Does any one have any suggestions of how this might be achieved?

Thanks

ahur

Not sure what you mean by "deploy".

Do you have a cube already you have built? Are you planning to create a new cube in Analysis Services and start writing data directly into it instead of processing cube based on the relational database?

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

|||

You can process the cube on one machine and then use either backup/restore or the Database Synchronization Wizard to move the processed database to another machine. If you are wanting to deploy to customers or to offline machines, then you may want to consider creating local cubes and copying these over.

Is this what you were looking for?

|||

Hi,

I have the same case, I need to deploy the cubes structure and data to another machine ( from development to production) , is there any way to achieve that?

Thanks

|||From what you describe, my posting earlier in this thread should provide some solutions. Please clarify your scenario if none of these solutions meet your needs.