cancel
Showing results for 
Search instead for 
Did you mean: 

Heterogeneous migration of BW

Former Member
0 Kudos

Hi ,

We are working on migrating our SAP BW 7.0 environment from HP-UX to AIX. Database is oracle on both source and target.

We are using table splitting and parallel export/import option to reduce downtime on our 3 TB system. We managed to cut down the export/import time to a good extent after some test migrations. But one table /BIC/FC_ZPP_RE is bothering us still which is taking more than 40 hours.

Is there any special way of handling the /BIC tables during export/import ? Any inputs on this will be helpful.

Regards

Krishna

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Also, check the indexes (using t-code RSA1) on the cube.


217397 - Indexing Scheme of BW facttables under Oracle

Former Member
0 Kudos

Any InfoCube whose table name begins with "/BIC/F" or "BIC/E" is a customized InfoCube, so you should work with the developers directly to help identify problems with the design of those cubes.

Additionally, InfoCubes are physically implemented using multiple partitioned tables. The tables that begin with "/BIC/F" (F-fact tables) are where the initial loads occur. Each new load request, creates a new physical partition in the F-Fact table. When an InfoCube is compressed, the F-Fact table is written to the E-Fact ("/BIC/E") table. Ideally, you shouldn't have very many individually partitioned loads in the F-Fact table (maybe 2-4 weeks worth at most).

Make sure your BW administrators are compressing their InfoCubes regularly. It sounds like the InfoCube you mentioned may have too many load requests that have not been compressed.

Former Member
0 Kudos

Thanks Stephen for your response. I asked my BW admin to have a look. I will come back once I hear from them