Tips for BW

Converting Standard InfoCubes to SAP HANA Optimized InfoCubes

1. Login to the SAP NetWeaver BW system.

2. Call up Transaction RSMIGRHANADB or the program RSDRI_CONVERT_ CUBE_TO_INMEMORY.

The job is executed in the background as a stored procedure. After the job is finished, the standard InfoCube is converted to an SAP HANA optimized InfoCube.

After the conversion, the InfoCube dimension tables are removed, and the master data tables are now directly linked with the F-fact table.

 After the conversion, the InfoCube dimension tables are removed, and the master data tables are now directly linked with the F-fact table

 

Modeling InfoProviders with the Composite Provider

 
You can avoid data redundancy or extensive coding when modeling data relations with the use of the composite provider and joins.