How to convert Classic Infocube/DSO to HANA optimized cubes/ DSO

from SDN.sap.com

We can convert Standard info cube into In-Memory info cube by using  the Report “RSDRI_CONVERT_CUBE_TO_IN-MEMORY ”. Or Call transaction RSMIGRHANADB directly.

To add the option of conversion of DSO also in the same program/T-code we can add the parameter ENBL_HDB_MIGR_DSO = X in RSADMIN Table.

During a conversion a lock is set, preventing all maintenance activity and load processes.. The conversion is executed as a Stored Procedure within HANA and therefore shows an excellent performance.

During conversion DataStore objects are not available for reporting / staging.

Querying on the InfoCubes is however possible during this time.

After migration to the SAP HANA database, normal standard InfoCubes are in the SAP HANA database's column-based store and have a logical index (Calculation Scenario). In the analysis, they behave like BWA-indexed InfoCubes.

If the InfoCubes have data persistency in BWA, the content is deleted during the system migration to HANA and the InfoCubes are set to inactive. If you want to continue using one of these InfoCubes as a standard InfoCube, you need to activate it again and reload the data from the former primary persistence (DataStore object for example).

We can make DSO as an In-Memory based DSO only if it is of Standard type.

Only DSO of type “Standard” can be converted to In-Memory DSO.

Also Standard DataStore objects can be converted into SAP HANA-optimized DataStores only if:

• The DSO is not included in a BW 3.x data flow (for example, by using update rules).

- Exception: If you use the BW 3.x data flow only on an inbound basis (but not on an outbound basis), you can still convert the DataStore. However, in general, we recommend that you migrate the old data flow before converting the DataStore.

See: http://help.sap.com/saphelp_nw73/helpdata/en/8d/6b1b58cc1744e1b

ce7898a50e19368/frameset.htm

• DSO is not supplied by real-time data acquisition

- Since small data volumes are usually produced for each activation step when data is supplied by RDA, RDA-supplied DataStores do not benefit in the same way as staging-supplied objects. Continue to use classic DataStore objects for this use case instead.

• DSO is not part of a HybridProvider or a semantically partitioned object (SPO).

- You can recreate SPOs based on SAP HANA-optimized DataStore objects.

Different options available for DSO migration:

1. Simple Migration
2. Full Migration

1. Simple Migration:

Only Active data gets converted and change log history gets deleted. Conversion is faster and requests cannot be rolled back after migration.

2. Full Migration:

Active data gets converted along with change log history. Conversion is slower but there is no restriction on rollback of requests.

Conversion Steps and Log Overview

?0?1Create temporary fact table with “flat” structure Z0<InfoCube>

?0?1 Read data out of the original fact tables dissolving the star schema and save data in temporary fact table

?0?1 Rename package dimension database table TP<InfoCube> Rename validity table (in case inventory mgmt InfoCube) TL<InfoCube>

?0?1 Empty the InfoCube tables

?0?1 Set InfoCube subtype to “flat”

?0?1 Activate the InfoCube - As it is empty the structures and their DDIC description can be adjusted

?0?1 Delete Fact DB-table and rename the temporary one

?0?1 Delete PDIM and rename the temporary one

?0?1 Delete validity table and rename the temporary one

?0?1 Delete temporary DDIC objects

?0?1 Create logical index

(This can be done with transaction RSMIGRHANADB)