Show TOC

Procedure documentationCreating TransientProviders on an SAP HANA Model

 

You can create a TransientProvider by publishing SAP HANA models in the BW system. The SAP HANA models published in the BW system are saved as an analytic index. This represents a view of the data in the SAP HANA model.

A TransientProvider is generated on this analytic index. A TransientProvider based on an SAP HANA model is suitable for ad hoc data or scenarios that change frequently.

These TransientProviders can thenbe 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. If the SAP HANA model is changed, the analytic index is adjusted automatically at runtime.

Note Note

A TransientProvider on an SAP HANA model cannot be used as a data target in Analysis Process Designer.

End of the note.

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.

At runtime, virtual analysis authorizations are created using an Analytic Privileges mapping and are then tailored to the authorizations that the database user (SAP<SAPSID>) has for the schema in the SAP HANA database. Only those Analytic Privileges are used where the relevant InfoObjects are flagged as authorization-relevant in BW. An exception to this are users with analysis authorization object 0BI_ALL. Only the authorizations of the database user (SAP<SAPSID>) are included for these users.

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 system 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/hanaInformation published on SAP site 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 the BW system. 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 is created, and the TransientProvider is generated. It is given a generated name in the following format @3<Name_Analytic_Index>. The InfoObjects are given a generic name following the pattern <Providername>@<column_name/alias>.

Result

You can use the analytic index in CompositeProviders.