Remodeling an InfoCube in BW 3.5

[Former Member]

Hallo experts!

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

- remodel

- 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?

Best Regards,

Peter

[Former Member · Accepted solution]

hi,

i think that your steps are correct.

the compression only aggregrate the data from different request into a e fact table.

so even when data is compressed the the uncompressed data id present in f fact table so i think there may not be any problem.

[Former Member]

Thanks to all for answer!

[Former Member]

Thanks for your answers. One last question. We have the idea to transfer InfoCube-data into the PSA of itself. From A to A.

Wouldn't that be a good way? I don't need to copy the InfoCube, make update-rules and so on.

Or could that be a problem. Any experiences?

Best regards,

Peter

[Former Member]

Peter

I am not sure how it works copying data into PSA. My suggestion is create cinfo cube and you could also copy update rules. Lets wait for the experts answers also.

Thanks

sat

[Former Member]

Peter

In my opinion you have the best way of doing and proceed with this model. info cube is better than ODS because you are copying data from Cube to cube so that structure will be the same.

I didn't get your compression question correctly but there won't be any issues if you copy data from existing compression cube to other cube.

Hope this helps

Thanks

Sat