Show TOC

Procedure documentationCreating CompositeProvider in the Analysis Process Designer 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.

A CompositeProvider created in the analysis process designer can only contain analytical indices.

Prerequisites

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

You have already created one or more analytical indices, either in APD or by publishing SAP HANA models in BW. More information: Creating TransientProvider on SAP HANA Models

Procedure

  1. You are in the analysis process designer. 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.