Show TOC

To create a CompositeProviderLocate this document in the navigation structure

Context

In a CompositeProvider, you can combine all the data that you want to view in your query. You can use all central BW InfoProviders assigned to the workspace as data providers, as well as your own data assigned to the workspace as local providers.

Procedure

  1. Insert the query that you want to enhance with a local provider.
    The query must belong to the same workspace as the local provider.
  2. Select a cell of crosstab.
  3. Choose Start of the navigation path Add Next navigation step Dimension End of the navigation path or Start of the navigation path Add Next navigation step Data Records  End of the navigation path in the Data Source group.
    Note If you want to add measure data to a query, we recommend adding it as data records.
    The Define Composite Provider Settings dialog appears.
  4. Select a local provider from the list.
    You can specify whether the local providers for all dimensions in the query should be listed, or jus for one dimension that you select in the drop down list.
    If you select a local provider, the data source details are displayed.
  5. Press Next.
    In the Details dialog, you can enter a description and technical name for the new CompositeProvider and the new data source (composite provider query).
    The technical name of the composite provider has the same predefined prefix as the local provider. The technical name of the composite provider query starts with the predefined prefix containing the elements $ and the workspace prefix.
    If you add a local provider to a composite provider, you cannot change the descriptions and technical names. These can only be assigned when the first local provider is added to a query.
  6. Press Next.
    In the Target Location dialog, you can specify whether the CompositeProvider should be inserted into the current workbook sheet or a new one. You can also specify that it should not inserted into a sheet.
  7. Press OK to create the CompositeProvider.
    Note

    You can use the graphical view or the table view in the BW Workspace Designer to check the field connections.

    For more information on the BW Workspace Designer, see the SAP NetWeaver BW documentation at http://help.sap.com/saphelp_nw73ehp1/helpdata/en/93/3bf44f28384d86ace3bb061a14851c/content.htm?frameset=/en/92/e1cfdf93194cf4a298aef9cae66856/frameset.htm

Results

The composite provider is created in the workspace. You can insert it as a data source into a workbook and analyze the data. You can also add new dimension or data records to the composite provider.