Skip to Content

Modeling
of Composite Provider in HANA studio (BWMT- CP)

At HANA studio Level (BW Modelling Tool
(BWMT))

After login to Hana studio, go to BW modeling (if it not available you need to install BWMT. To do that go help in menu bar, install update give https://tools.hana.ondemand.com/luna click add. Now you can few addons, select the check box BW modelling)

Go to Info area folder where you want to create the composite and right on the composite provider folder>select New>Composite Provider.

/wp-content/uploads/2015/07/1_749965.png
  
 
You will be having below prompt, fill with Technical Name in the NAME field and Description. Select root Operation radio button as per your requirement. In my example used Union.

/wp-content/uploads/2015/07/2_749492.png

After u click on finished, you will be able to find the below screen.

/wp-content/uploads/2015/07/4_749981.png

Now you are in the General Tab, here you can find the two check box. One can enable or checked to use this composite provider as External HANA View and other one is to enable this composite provider to make available for re-use in another composite provider.

Click on the Scenarios for Graphical modeling.

/wp-content/uploads/2015/07/4_749981.png

Move on the cursor over the Union Graphical icon which highlight the database cylinder
icon.
Click on it to add the object. Here u can see along with database cylinder icon we have info
set and delete icon.


/wp-content/uploads/2015/07/5_749499.png

We can see the Graphical area source and target is empty

/wp-content/uploads/2015/07/6_749500.png

 

We can search the object select the object and click ok. In my case object means DSO, but object means anything like Master data info object, DSO’s, Info sets, Multi Providers and Composite providers

/wp-content/uploads/2015/07/7_749859.png

Once the object is added you can find the source column is filled with fields which are from the object those contained.

/wp-content/uploads/2015/07/8_749860.png

Right click on the object in the source as shown and click on create assignments. All the fields which are present in the source will be mapped to target. You can add required fields from particular object by selecting the each field and move into target. (Use ctrl to select multiple select and drag drop into target)

/wp-content/uploads/2015/07/9_749903.png

For adding one more object you have to follow the same procedure by clicking on cylinder icon and select the required object and click ok. You will able see as below once you done with this step.

/wp-content/uploads/2015/07/10_749904.png

And create assignments.

23.PNG


/wp-content/uploads/2015/07/12_749912.png

The Common fields from both Objects are mapped automatically and unique fields will present with map to it respective source object. 

22.PNG

In this way you can add the few object, if you add more object, the performance degrades.It recommended not use more than 10 objects in one composite provider.

21.PNG

If you want to add join condition using other objects,  then right click on the Union and select Join
with.. or you click on /wp-content/uploads/2015/07/q_749933.pngwill get below pop and click on ok

20.PNG

19.PNG

You make left outer Join and inner, Default it takes inner Join.

17.PNG

18.PNG

Thanks

Madhukar M

To report this post you need to login first.

9 Comments

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

  1. Rohith D

    Thanks for sharing the document .

     

    I have a question here , when we add a JOIN which is mapped to UNION ( as shown in below picture) , I am getting error “JOIN CONDTITION MISSING FOR JOIN J1”.

     

    Untitled picture.png

    Please let me know where I am missing the join condition .

     

    Thanks

    Rohith

    (0) 
  2. Loed Despuig

    Hi guys,

     

    http://scn.sap.com/thread/3877086

     

    Just want to ask if this is possible in Hana Studio?

     

    For example, I have these fields:

     

    DSO1:

    STATION

    STATION__CUSTOMER (nav attribute of STATION)

    AMOUNT

     

    DSO2:

    CUSTOMER

    QTY

     

    Is it possible to join the STATION__CUSTOMER to CUSTOMER field in Hana Studio? In tcode RSLIMOBW I can do it, I don’t know if that’s also possible in Hana Studio..Tried and searched for ways but still no luck..

     

    Thank you..

     

    Loed

    (0) 
    1. Lourdes Raj

      Can you try creating a composite provider (CK1) just for DSO1 with STATION__CUSTOMER (nav attribute of STATION) checked.

      You can use theĀ  (CK1) in another composite provider and join with DSO2.

      (1) 

Leave a Reply