Show TOC

CompositeProviderLocate this document in the navigation structure

A CompositeProvider is an InfoProvider that which combines data from analytic indexes, or SAP HANA views or from other InfoProviders by Join or Union, and makes this data available for reporting and analysis.

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

There are three different types of CompositeProviders, designed for different user groups and application areas.

  • (Central) CompositeProvider:

    In the Eclipse-based BW Modeling tools, BW developers can flexibly combine data from multiple InfoProvidern and SAP HANA views. In future, this CompositeProvider will be the central CompositeProvider that forms the virtual data mart layer that provides the data for reporting and analysis when using an SAP HANA database. It replaces the ad hoc CompositeProvider if you are using SAP HANA.

    More information: Creating CompositeProviders

  • Ad hoc CompositeProvider:

    • consists of InfoProviders and analytic indexes: 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

    • consists of analytic indexes: 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 CompositeProviders in Analysis Process Designer

  • Local CompositeProvider:

    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

Prerequisites

You are using a SAP HANA database or a SAP BW Accelerator. The BW Modeling tools are only available if you are using SAP HANA.

Constraints

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

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

If you are using a BWA, the open request is not read in the query for real-time InfoCubes for local CompositeProviders, even if you have made the corresponding data integrity setting in Query Designer. If you are using an SAP HANA database, the open request is read.

Related Information