Show TOC

Procedure documentationCreating CompositeProviders in the Data Warehousing Workbench

 

Prerequisites

Unlike a CompositeProvider that you create in the Analysis Process Designer by choosing Start of the navigation path Environment Next navigation step Edit CompositeProvider End of the navigation path, you can transport a CompositeProvider that you create in the Data Warehousing Workbench.

Prerequisite for transporting:

  • The CompositeProvider does not contain an analytic index.

  • The InfoProviders that make up the CompositeProvider are already available in the production system.

  • You have installed the R3TRANS version, released on 5th September 2011 (720-R3TRANS-Patch).

  • You have installed the SAP Note 1643629.

CompositeProviders can also be delivered as BI Content, if they only consist of InfoProviders.

Caution Caution

During the content installation, if there is an A version of a CompositeProvider, it might be overwritten by the D version.

End of the caution.

Procedure

  1. You are in the Modeling area in the Data Warehousing Workbench. In the context menu of the InfoArea, choose Create CompositeProvider....

  2. Enter a name for your CompositeProvider. The maximum length of the name is 10 characters. The system adds the prefix @3 to the InfoProvider name.

  3. Press OK (OK). The graphical modeling environment appears.

  4. You can drag and drop the required InfoProviders (from the InfoProvider tree on the left of the screen) onto the modeling area.

    Note Note

    For MultiProviders, only the InfoProviders that are indexed are transferred. The links (Unions) of the MultiProvider are automatically transferred. Once the individual InfoProviders are contained in the CompositeProvider, it is no longer relevant that they are part of a MultiProvider.

    End of the note.

  5. In a dialog box, you can define whether to link by Union or Join. Press OK. The selected InfoProvider is displayed in the modeling area. You can now select more InfoProviders.

  6. Now drag the fields from the InfoProviders to your empty CompositeProvider. Using lines, the system now shows which InfoProviders the fields come from. If a line is a join, it has the label Join and is displayed in bold.

  7. You have various options for checking the join connections. More information: Extended Checks

  8. You can change the name of a field and enter a description. To do this, choose Start of the navigation path Properties Next navigation step Change End of the navigation path from the context menu on the field.

    Note Note

    The maximum length of the field names is 10 characters. If they are longer, the system assigns the name F001, F002 and so on. If a field name already exists, a Fnnn name is assigned. The descriptions are always taken over from the original field.

    End of the note.

  9. For key figures, you can assign a currency or unit from a characteristic. To do this, choose Start of the navigation path Properties Next navigation step Change End of the navigation path from the context menu on the key figure.

  10. You can make the following settings by choosing Start of the navigation path Goto Next navigation step Global Settings End of the navigation path:

    • Select MultiProviders for Pruning:

      If you select a MultiProvider for the CompositeProvider, when the CompositeProvider is accessed, the information from the MultiProvider hint is used to exclude individual InfoProviders during the access. This can help to improve performance.

    • Derive Authorizations from Analysis Authorizations Only:

      If you set this indicator, only the analysis authorizations created for the CompositeProvider are used for the authorization check. Otherwise, the authorizations in the CompositeProvider are derived from the InfoProviders involved. To do this, the system takes the intersection of the various InfoProviders. The analysis authorizations created for the CompositeProvider are then merged with the derived authorizations.

  11. For information about other editing functions, see: Further Functions for Editing CompositeProviders

  12. You can also fill a field from a constant. To make this possible, at least two analytic indexes must be used a a union.

    To do this, choose Constant from... from the context menu for a field that is not connected with all union indexes.

    Example Example

    An analytic index 1 contains the Country field, while an analytic index 2 only contains data for Germany, without the Country field. To be able to connect all fields correctly by union, the Country field must be linked from both analytic indexes.

    In the CompositeProvider, set the constant for Country to DE (Germany). This means that the field in the CompositeProvider from analytic index 2 is always filled with Germany.

    End of the example.

  13. You can view the CompositeProvider's XML structure.

  14. Activate the CompositeProvider. When the CompositeProvider is activated, the data is stored in BW Accelerator or the SAP HANA database. You can now view the data by choosing Display Data. You can display documentation for the CompositeProvider in the initial transaction SLIMOBW by choosing Start of the navigation path Goto Next navigation step Description End of the navigation path.

Result

You can create queries on the CompositeProvider.