SAP BW on HANA - Advanced DSOs

Using HANA optimized objects, you can achieve better performance for analytical reporting and data analysis. DSOs of SAP BW are automatically optimized for activation in SAP HANA database. When you migrate SAP BW on HANA, all standard DSOs are moved to SAP HANA database in a column storage.

To use advanced DSOs, you should have SAP HANA database support pack 08 or higher version and in the backend you should have SAP BW 7.4 SPS9.

Create an Advanced DSO Based on HANA Database

Go to SAP HANA studio → BW Modepng Tools

To create an Advanced DSO, right-cpck on your InfoArea and choose New DataStoreObject (advanced).

Provide the following details and cpck Finish.

Enter the name of DataStore - The technical name can be between three and nine characters long. If you have a namespace for the DataStore object (advanced), the name can only be eight characters long.

Description of the DataStore

Select an Object Template

You can create a Transformation from your standard DSO to Advanced DSO that you have created in HANA database. Go to SAP BW system, expand InfoCube and copy transformation from the existing DSO to the new Advanced DSO.

You can create a new transformation and load the data to new Advanced Data Store Object.