The SAP BW Composite Provider is used to bring the data together from in-memory data targets/InfoProviders. This InfoProvider can leverage both union and join operations to combine.
Purpose of Composite provider: one modeling InfoProvider (semantic layer) combining BW and HANA objects with either Join or Union.
UNION and JOIN operations are executed in HANA and not the application server. BEx queries can be created on Composite Providers as on any other BW InfoProviders.
Modeling Scenario using Composite Provider:
With the new Composite provider it is possible to realize the dream of storing the same data only once at least for this scenario. The following case shows how we can model the same scenario using a composite provider and thus make use of the calculation capabilities of HANA DB.
In transaction RSLIMOBW, we create a Composite provider that uses the 3 Data store objects, Sales Transaction, Customer Master and Product Master as shown below.
How this works:
Benefits of Composite Provider over MuliteProvider:
Creation of Composite provider.
Log on to the BW Modeling Perspective with your BW credentials and attach your HANA system using the context menu on your top project level folder, choosing the option Attach HANA system, without which you will not be able to include native SAP HANA models in your Composite Provider.
Navigate to InfoArea under BW Project → Context menu → New → Composite Provider.
Enter the Composite Provider name and description. Click Next.
Then click on the Add sign, you will be prompted if you want to select an InfoProvider or HANA view. To perform a search, enter ‘?’ and you will see a list of available objects. Select any object that you want to add to the Composite Provider.
Similarly, add an InfoProvider to your Composite Provider. Next is to add the fields from Source to Target by dragging the fields. You can use Expand all to expand all the objects added. You can also apply a filter to search a particular field.” Note that at least one field should be drop on join condition”.
Composite Provider created by using JOIN.
Composite Provider created by using UNION.
Go to the output tab and you can see the mapping of added objects.
Next is to check and activate BW object.
To preview the data in HANA Studio, use the magnifying glass icon in the upper right corner → Show Preview.
You can also analyze the result in the Problems log of this perspective.