Show TOC

Creating TransientProviders on SAP HANA ModelsLocate this document in the navigation structure

You can create a TransientProvider by publishing SAP HANA models in the BW system.

Context

Note

With SAP BW 7.4 SPS5 and higher, we recommend that you create CompositeProviders in BW modeling tools instead of TransientProviders on an SAP HANA model. You can find information in the BW Modeling tools, under Start of the navigation path Help Next navigation step Help Contents Next navigation step SAP - BW Modeling Guide End of the navigation path.

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

Note

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

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.

To publish SAP HANA models on the BW system, a generic R/3 user needs complete authorization for the SAP HANA model.

The user specified in the BW system is used for read-only access during the execution of a query. The analytic privileges of this user are checked in the SAP HANA model. The analysis authorizations are also checked in the BW system when an InfoObject is assigned. If a TransientProvider characteristic has restrictions on analytic privileges and on analysis authorizations, the conditions are joined using Union.

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.

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. Choose Continue. The definition of the analytic index is displayed.
  5. On the Properties tab page, you can assign an InfoArea to the 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

    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).

  7. Choose 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>.

Results

You can use the analytic index in CompositeProviders.