SAP HANA-Optimized Objects

After migration to the SAP HANA database, normal standard DataStore objects and standard DataObjects are contained in the SAP HANA database's column-based store. DataStore objects are automatically optimized for activation in SAP HANA. You should convert all existing InfoCubes and semantically partitioned objects that are based on InfoCubes into SAP HANA-optimized objects. This will allow you to enjoy the advantages of the SAP HANA database when loading data. When you create new standard InfoCubes or semantically partitioned objects, these are automatically created as SAP HANA-optimized objects.

Another advantage is the simplified data modeling. Using in-memory optimized objects means that it is not necessary to load to a BWA index for example, while the database architecture allows you for example to delete characteristics from an InfoCube that still contains data. Loading data from a DataStore object into a downstream InfoCube is also no longer necessary if the InfoCube is only intended to improve query performance.

To merge data from multiple analytic indexes or other InfoProviders (by union, inner join oder left outer join), you can use the CompositeProvider. Storing the data in the SAP HANA database facilitates rapid data access for reporting and analysis.