Skip to Content

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.

                                                       /wp-content/uploads/2014/11/0_582574.png

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

                             /wp-content/uploads/2014/11/1_582623.png

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

                             /wp-content/uploads/2014/11/2_582624.png

1 – 1 mapping is done between the objects

                              /wp-content/uploads/2014/11/3_582625.png

The below is the expected output for the composite provider:

                                        /wp-content/uploads/2014/11/4_582626.png

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.

                                /wp-content/uploads/2014/11/5_582627.png

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

                                                      /wp-content/uploads/2014/11/6_582628.png

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

                                             /wp-content/uploads/2014/11/7_0_583503.png

Goto T.code rsdd_hm_publish where we can generate a Transient provider from a HANA Analytical view

                    /wp-content/uploads/2014/11/7_583504.png

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

                              /wp-content/uploads/2014/11/8_583508.png

New analytic indexes will be created

                     /wp-content/uploads/2014/11/9_583509.png

Now Transient provider @3ZTEST_DS is created successfully

                                /wp-content/uploads/2014/11/10_583510.png

BEx query:ZTEST_SCN is created based on transient provider @3ZTEST where the data is consumed from HANA Analytical view on query execution.

                                 /wp-content/uploads/2014/11/11_583511.png

The below is the report output where the data is retrieved from HANA view via Transient provider

                             /wp-content/uploads/2014/11/12_583512.png

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.

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

    1. Sini Kumar

      How does the user security works?

      Does all end users needs to be in HANA studio too?

      Does it support analysis authorization?

      Do we need to maintain any additional security in HANA studio for the backend developers?

      (0) 

Leave a Reply