Show TOC

Procedure documentationPublishing SAP HANA Models Locate this document in the navigation structure

 

You can publish SAP HANA models in the BW system. Once published in the BW system, these SAP HANA models are saved as analytic indexes and can be linked to other BW InfoProviders in a CompositeProvider. This enables you to combine ad-hoc data with consolidated data from the BW system and also use the OLAP functions of the BW system for analysis.

An analytic index created as described above is also displayed in the analytic index overview. More information: Managing Analytic Indexes

To publish an SAP HANA model in the BW system, the system reads the structure of the SAP HANA model from the SAP HANA database. The BW system applies the structure to an analytic index. Models from any schema can be used here. The system automatically maps the authorizations from SAP HANA to the BW analysis authorizations:

In the SAP HANA database, analytic privileges are used to define which users are allowed to view which data records for analysis purposes. Analytic privileges are handled as filters for database queries. Users only see the data for which they have an analytic privilege. In BW, however, authorizations do not work as filters. Here, users can only execute a query if their analysis authorizations completely cover the relevant selection. If this is not the case, an error message is displayed. Analytic privileges are persisted on the BW system and in the SAP HANA database. The system creates virtual analysis authorizations at runtime by mapping the analytic privileges.

Note Note

The BW database user is always used every time the SAP HANA database is accessed. The BW database user and the BW user must be identical (1:1 user mapping), so that the analytic privileges of a BW database user can be mapped to the virtual analysis authorizations of a BW user.

End of the note.

More information:

Analysis Authorizations

BAdI for Virtual Analysis Authorizations

For more information about analytical privileges, see http://help.sap.com/hana in the SAP HANA Database Security Guide.

Procedure

  1. Run transaction RSDD_HM_PUBLISH.

  2. Select an SAP HANA model. The SAP HANA model is uniquely identifiable from the catalog that it is located in.

  3. Choose Create.

  4. The system uses the name of the SAP HANA model to generate a proposal for the name of the analytic index to be created. You can change this name. Press Continue. The definition of the analytic index is displayed.

  5. On the Properties tab page, you can assign an InfoArea to teh analytic index.

  6. On the Characteristics and Key Figures tab pages, you can assign BW InfoObjects to the fields. This means the metadata (of characteristics and key figures) on the flat view of the data is turned into a multidimensional view. The attributes of the referenced InfoObject are then displayed in the query. However, these attributes cannot be used as navigation attributes. It also means the authorizations on these InfoObjects are taken into account. SID are created for any master data values that do not exist in BW. Check/decide whether this is required.

    Note Note

    The data types of the SAP HANA model must match the data types of the InfoObject. Otherwise, no data is displayed (due to the consistency checks).

    End of the note.

  7. Press Save. The analytic index has now been created and given a generic name following the pattern @3<Name_Analytischer_Index>. The InfoObjects are given a generic name following the pattern <Providername>@<column_name/alias>.

Result

You can use the analytic index in CompositeProviders.

Modeling CompositeProviders for administrators: Creating CompositeProviders

Modeling CompositeProviders for business users: Creating CompositeProviders