Modeling of Composite Provider in HANA studio (BWMT- CP)
of Composite Provider in HANA studio (BWMT- CP)
At HANA studio Level (BW Modelling Tool
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.
After u click on finished, you will be able to find the below screen.
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.
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.
We can see the Graphical area source and target is empty
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
Once the object is added you can find the source column is filled with fields which are from the object those contained.
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)
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.
And create assignments.
The Common fields from both Objects are mapped automatically and unique fields will present with map to it respective source object.
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.
You make left outer Join and inner, Default it takes inner Join.