HANA Optimized InfoCubes in SAP BW on HANA

What is HANA Optimized InfoCubes?

When you operate SAP BW on HANA, you could create your current InfoCubes to HANA Optimized InfoCubes. when InfoCubes are moved to HANA database, they grow to be column-based tables and act like BWA listed InfoCubes.

while SAP HANA-optimized InfoCubes are used, traits and key figures are assigned to dimensions. to enhance the system performance, Surrogate IDs (SIDs) are used in fact tables.

when you exchange popular InfoCubes to HANA-optimized InfoCubes, the layout adjustments at the time of conversion and it must be adjusted manually.

To view InfoCubes in the BW system, you may use Transaction: LISTSCHEMA.

view_infocubes

You can select your InfoCube and check the various dimension tables. Select InfoCube type −

  • Aggregate Cube
  • Standard InfoCube

select_infocubes

infocubes

call_up_schema_viewer

There are two ways to convert standard InfoCube to HANA optimized InfoCube.

Go to InfoCube and click to open the editing screen. Select Conversion to SAP HANA optimized checkbox. You can also check this property under InfoCube properties → Subtype. Open InfoCube and you can see the subtype as HANA optimized InfoCube.

infocube_properties

You can also call Transaction RSMIGRHANADB in BW system. This transaction will directly open the screen to convert objects to HANA optimized objects.

call_transaction

You can select the object type and enter the name of the object. In the following screen, I have selected a standard InfoCube to convert to HANA Optimized InfoCube.

You can also select an option to view the logs after conversion.

select_options

When the selected object is already HANA optimized object, or conversion is done, you will get the message as shown in the following screenshot.

selected_object


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

SAP BW on HANA Topics