Hi Everyone,
Today i would like to discuss how we can Consume SAP HANA Models in SAP BW using Transient Provider
To create a transient provider based on HANA Model: run the transaction RSDD_HM_PUBLISH.
After that we will see the below screen:
We will select the package and HANA Model that we want to consume in BW.
We can select model from any of the schemas present in HANA database.
Then we will click on create button and it will create an Analytic Index.
The system uses HANA model name to generate the name for the analytic index it is creating.
After this select OK and then we will get the following screen:
BW system reads the HANA model structure and then creates a structure for the Analytic Index.
The name of generated Transient Provider is @3[AnalyticIndexName]
As seen in the Properties tab here our transient provider name is @3ESALES.
Now we will assign our transient provider to an InfoArea
Remember one thing that the Transient Provider will not be visible in the BW Administrators workbench (RSA1), therefore it is not possible to combine it with any other InfoProviders like Multi Provider or Hybrid Provider except for Composite Provider.
Now, if we go to Characteristics tab we will get the following Screen:
And on going to the Key Figures tab, we will see the following screen
As seen above Transient InfoObjects are automatically generated for the fields present in HANA model.
Now if we want we can assign Reference InfoObjects to any of these Transient InfoObjects or to all Transient Objects.
Then this transient InfoObject can have a reference to a real InfoObject and thus it can inherit its Metadata as well as Master data (like description, texts, display properties, display attributes and hierarchies).
The metadata of the InfoObjects that is in the flat view is converted to a multidimensional view. The attributes of these referenced InfoObjects are then displayed in the query. However, these attributes cannot be used as navigation attributes.
Remember that if we are using Reference InfoObject then SAP HANA model data types and InfoObject data types should match otherwise no data will be displayed.
Now Save the model.
Thus, A Transient Provider is an InfoProvider on which a we can execute BEx query without the need for the InfoProvider to be modeled in the Data Warehousing Workbench or the data to be replicated.
The modeling is derived from an analytic index. When we activate an analytic index, a Transient Provider is automatically created by the system.
The metadata of a Transient Provider is not saved. This data is generated at runtime.
The name of a Transient Provider is @3[AnalyticIndexName]
Restrictions that are applied while creating HANA based Transient Provider:
Authorization Concept:
Benefits of HANA based Transient Provider:
Limitations of HANA based Transient Provider:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
7 | |
5 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 | |
3 | |
3 |