Show TOC

Background documentationCompositeProvider

 

A CompositeProvider is an InfoProvider that combines data from several analytic indexes or from other InfoProviders (by union or inner join or left outer join), and makes this data available for reporting and analysis.

Storing the data in BW Accelerator or in an SAP HANA database also ensures faster access to data in the query.

There are three modeling areas for CompositeProviders, which are configured for different user groups and application areas.

  • In BW Workspace Designer:

    Business users can easily combine their own data from files with data from BW (DataSources, queries, or InfoProviders).

    More information: Creating CompositeProviders in BW Workspace Designer

  • In the Analysis Process Designer (APD):

    Administrators can flexibly combine data from multiple analytic indexes in a graphical environment to quickly create a prototype. The data for the analytic indexes can be taken from both the possible data sources of the APD or from SAP HANA models.

    More information: Creating CompositeProvider in the Analysis Process Designer

  • In the Data Warehousing Workbench

    Administrators can flexibly combine data from multiple InfoProviders and analytic indexes in a graphical environment. The CompositeProvider offers more options than working with InfoSets or MultiProviders. However, you should always check carefully when using the CompositeProvider to ensure that you are receiving the desired result.

    More information: Creating CompositeProviders in the Data Warehousing Workbench

The authorizations for working with CompositeProviders are assigned using the authorization object S_RS_CPRO.

The analysis authorizations are created from a combination of the authorizations for the CompositeProvider and the authorizations for its subobjects. For more information and an example, see: Authorizations for CompositeProvider

Prerequisites

You are using an SAP HANA database or an SAP NetWeaver BW Accelerator.

Constraints

A CompositeProvider can only be transported if it consists solely of InfoProviders.

You cannot use any non-cumulative key figures in a CompositeProvider.