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 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.
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:
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.
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.
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:
BAdI for Virtual Analysis Authorizations
For more information about analytical privileges, see http://help.sap.com/hana in the SAP HANA Database Security Guide.
You can use the analytic index in CompositeProviders.