Hi Friends,

I would like to share a small information regarding Indexing DSO data in the BWA.

System Version:

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.

Step 1:

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”.

Pic 1.jpg

Step 2:

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.

Pic 2.jpg

Step 3:

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).

Pic 3.jpg


Step 4:

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.

Pic 7.jpg

Step 5:

Now create transformation with direct map from DSO to Cube. After that create DTP.


Step 6:

Now run the DTP which transfer the DATA from DSO to cube. Once complete, manage the BWA Only Cube.

Pic 5.jpg

Step 7:

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.


Pic 8.jpg


Note:

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


Pros:

Improve the reporting performance as compared to DSO.


Cons:

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


Thank you.


Regards,

Pradeep Kumar Das.


To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply