Skip to Content

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

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

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