Cube Impact due to change of database

[senbi]

Hello Everybody,

My requirement is to centraize the cube. So need to change the database from Oracle to SQL Server. Pls give suggestion what would be the impact on cube/reports if the database migration is done?

-Senbi

[BIsrik]

If the cube is already built then there is no effect on these changes on the cube. If it is to built then the source has to first updated and then the cube has to be created.

If it is built and needs an incremental update then again the source has to be updated keeping in mind the information like the columns needed, the column datatype etc doesn't change.....

Before u proceed take the backup of model and the cube...both of them..

Srik