Show TOC

Procedure documentationCreating CompositeProviders Locate this document in the navigation structure

 

A CompositeProvider is an InfoProvider, which combines data from several analytic indexes or from other InfoProviders (by Join or Union), and makes this data available for reporting and analysis. The CompositeProvider is defined in a graphical environment, thus faciilitating rapid modeling. This makes it possible to bring together data from multiple sources using analytic indexes and to quickly put together a prototype. Storing the data in BW Accelerator or in SAP HANA also ensures faster access to data in the query.

Prerequisites

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

Procedure

Creating CompositeProviders from Analytic Indexes Only

  1. You are in Analysis Designer, where you have already created at least one analytic index. Choose   Environment   Edit CompositeProvider  . The screen for editing CompositeProviders appears (transaction RSLIMO).

  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. Choose Create. The graphical modeling environment appears.

  4. Initially, the CompositeProvider to be created is displayed as an empty object. The InfoProvider tree is displayed on the left. By selecting Hide Empty Folders, you can restrict the view to InfoAreas containing analytic indexes.

    Find the analytic index that you want to use in the CompositeProvider. Drag and drop it onto the modeling area.

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

  6. Now drag the fields from the analytic indexes to your empty CompositeProvider. Using lines, the system now shows which analytic indexes the fields come from. It 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   Properties   Change   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   Properties   Change   from the context menu on the key figure.

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

  11. 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.

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

  13. 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.

Creating CompositeProviders from Analytical Indexes and from other InfoProviders

  1. Call transaction RSLIMOBW.

  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. Choose Create. The graphical modeling environment appears.

  4. You can drag and drop the required analytic indexes (from the tree on the left of the screen) onto the modeling area. Choose Provider Display to view the other available InfoProviders.

  5. Proceed as described above, starting with step 5.

    Note Note

    Unlike the CompositeProvider that you create using transaction RSLIMO, you can transport the CompositeProvider from transaction RSLIMOBW.

    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.

    End of the note.