I would like to share a small information regarding Indexing DSO data in the BWA.
SAP NetWeaver 7.3
SAP BWA 7.20
Requirement: Some time we faced performance problem in reporting while reporting on top of DSO data. If we have BWA on top of our SAP NetWeaver, we can leverage the benefit of BWA, indexing DSO data on BWA.
Here I will explain how to index DSO data in BWA.
Create a new InfoCube with the DSO you want to index as the template. Select from the BWA status drop down: “InfoCube only stores its data in the BWA”.
Here we can see the structure of the cube. It takes the DSOs characteristic fields and throws it all into Dimension 1. All the DSOs key figures get put into the key figures folder of the cube. Activate the InfoCube.
In transaction RSDDB (SAP BW 7.3, BWA transaction) we can see the index is red which means it is in the process of being created (ZBWAONLY1).
Now activate the BWA for the InfoCube. After activation you can observe that RSDDB Index Info, note the F table has an Index Size of 0.
Now create transformation with direct map from DSO to Cube. After that create DTP.
Now run the DTP which transfer the DATA from DSO to cube. Once complete, manage the BWA Only Cube.
When we go back to RSDDB and go to index info we can see that since the DTP completed, the F table index has records sitting in the BWA.
-> We can use this cube for direct reporting as well as we can add this to Multiprovider for reporting also.
-> The cube doesn’t hold data physically, Data Persistency Only in BWA.
Improve the reporting performance as compared to DSO.
-> Additional time require to load data from DSO to BWA.
-> Once data deleted from BWA, no data available for reporting.
Please share your experience about this if you have additional information.
Pradeep Kumar Das.