This blog contains 2 scenario’s a) Integration of BW master data with transaction data which is retrieved from HANA Analytical view via BW composite provider b) Integration of HANA view in BW using Transient Provider for reporting in BEx.
a) Integration of BW master data with transaction data which is retrieved from HANA Analytical view via BW composite provider
In this scenario we have used the new eclipse based modeling environment where BW modeling can be done in HANA studio – BW Modeling perspective
Let us consider the integration scenario as shown below where BW master data is integrated with Transaction data via HANA view using a composite provider.
We have created a new composite provider ZSCM_COMP in eclipse environment.
We have 3 tabs available while creating a composite provider 1) Overview:Provides properties of the Composite provider 2) Scenario: All the mappings of the objects will be done 3) Output: Expected output fields will be available
In the scenario tab:Union operation is done between HANA Analytical view:ZTEST_DS and BW Master data infoobject ZCUST_SC
Here customer data is populated from Customer Infoobject and transaction data is populated from HANA view:ZTEST_DS
1 – 1 mapping is done between the objects
The below is the expected output for the composite provider:
After successful activation of composite provider, data can be previewed in HANA studio as below, where for each city,sales area, customer – no of products purchased and cost are shown.
As the composite provider is created in back end HANA DB, it will be automatically reflected in BW system as shown below, where we can create BEx queries as per the reporting requirements
b) Integration of HANA view in BW using Transient Provider for reporting in BEx.
This scenario explains how a HANA Analytical view can be be converted to BW Transient provider where it can be consumed for BW reporting purposes
Goto T.code rsdd_hm_publish where we can generate a Transient provider from a HANA Analytical view
Note: We are using an already available HANA view:ZTEST_DS
Enter the desired Information model by selecting the relevant HANA package to generate a transient provider
New analytic indexes will be created
Now Transient provider @3ZTEST_DS is created successfully
BEx query:ZTEST_SCN is created based on transient provider @3ZTEST where the data is consumed from HANA Analytical view on query execution.
The below is the report output where the data is retrieved from HANA view via Transient provider
To conclude we have many other integration scenario’s available from BW 740 SP5 and above where there is a flexibility to the end user on usage of objects based on client requirement.