jueves, 4 de junio de 2015

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.

 


 

 



  SAP BW 4hana DTP ABAP Filter Range using DTP Routine data: lv_date_low TYPE sy-datum, lv_date_high TYPE sy-datum, lv_date TYPE dats, lv_mo...