Composite Provider

See more in our hbite on Composite Provider

A CompositeProvider is a special type of InfoProvider that combines reporting data from several
InfoProviders. The CompositeProvider itself does not contain any data, its data comes from the InfoProviders which it contains.

As per latest BW4HANA release, SAP recommends to create reports based only on composite providers.

You can change the InfoProviders inside the CompositeProvider without changing the report.

CompositeProviders are used for the following reasons:

● For building reports, composite provider act as a separate layer in the datawarehouse.

● the composite provider make up the data mart layer. If there are any changes in the underlying adso, the composite provider and reports remain unchanged.

● Smaller infoproviders that are semantically partitioned (e.g. APAC, Europe, Americas) can be combined using UNION in composite provider. This helps in performance gain in reports as well as data loading.

Composite providers are similar to database views which give access to data from multiple tables.

It is completely HANA optimized. This means that the join operation occurs in HANA database and not in application layer improving performance in great way. In BI7 Infosets, the join operations used to occur in application layer and hence infosets show poor performance.

It can contain all types of BW objects or can be built purely on HANA views.

One composite provider can be part of another composite provider.

In BW on HANA, a tcode RSLIMO was used to create composite provider.

With BW4HANA, creation and editing of Composite Provider is purely eclipse based.

The join types available are UNION, INNER or LEFT OUTER.

Below are steps on how to create composite provider in BW4HANA eclipse based environment

In the BW modeler perspective, logon to your BW project
Click on your info area and select new->composite provider

Give a name and description and select the provider type as JOIN or UNION.
Select the type of join and add your objects (BW object or HANA views)
Go to scenario tab, create assignments

add the key figures and characteristics that are required in target
note that currency or unit is automatically added if we add any key figure of type unit or currency
In the output tab, you can assign infoobjects to CP fields to have master data in report (navigation attributes can be checked in CP). You can also right click on any field in target and select ‘Edit’