What is the best way to remodel dimensions of an productive InfoCube?
What I know:
- copy InfoCube A to InfoCube B
- generate an exportDataSource on A
- load data in B from A
- delete data in A
- generate an exportDataSource on B
- load data in A from B
Is this the best way? Any other Ideas? If I have a very large InfoCube, is it the best way to have an InfoCube as B? Wouldn't be an ODS-Object better because It maybe is faster to write in and read from a flat table?
Is it a problem if the InfoCube is compressed?
Anything else I should know?