Show TOC

Creating Join AssignmentsLocate this document in the navigation structure

You define the CompositeProvider by selecting other participating InfoProviders or SAP HANA views and creating assignments. This section describes assignments by join.


  1. You are on the Scenario tab page.
  2. Define the join condition. To do this, open the context menu on a source field and choose Create Join Condition Field. Then select a join partner for the field.
  3. If the join providers are analytic indexes or SAP HANA views, you can change the cardinality by choosing Edit Cardinality in the context menu for a provider. For all providers, the cardinality is calculated initially by the system. If the join condition or one of the providers is changed, the system checks the cardinality and changes it if required.
    Note The cardinality setting can improve the performance but can also produce incorrect data. Therefore in most cases you should not change the cardinality suggested by the system. An expert might need to change the suggested cardinality if the system does not recognize the data contents and s/he knows how to configure a more precise cardinality setting.
    The following change options are available:
    System proposes Possible change
    n:m 1:m, n:1 or 1:1
    1:n 1...1

  4. The field types are distinguished by their icons:
    • Characteristic:
    • Time characteristic:
    • Unit:
    • Key figure:
    In the graphical display, you can make the assignments either using drag and drop or by choosing Create Assignments. On the left, you see the participating providers. To the right of these, the CompositeProvider's fields are displayed. Create assignments by choosing Create Assignments in the context menu. If you add an InfoProvider by drag and drop, the fields and dimensions (groups) of the InfoProvider are applied and any required dimensions that do not already exist are created. You can also add complete dimensions by dragging the dimension to a free area or onto the root node. If you drag a dimension onto another dimension, only the fields are added to the new dimension.
    In the case of BW InfoProviders, the dimensions are added as groups. If a field does not exist yet in the row structure, the system creates it. If navigation attributes have been added to the CompositeProvider, they are not navigation attributes any more.

    When a CompositeProvider is opened again, only navigation attributes that have been assigned are displayed in the Scenario tab page. To see all navigation attributes of a participating InfoProvider, choose Show Unassigned Navigation Attributes in the InfoProvider's context menu. If you want to hide it again, choose Hide Unassigned Navigation Attributes in the context menu.

    If InfoObject names have been assigned to the fields of the SAP HANA view, these InfoObject names are used to create an association for the field in the CompositeProvider for SAP HANA views. When fields are assigned to the CompositeProvider, the associations are automatically set.

    If a SAP HANA view contains input parameters, these are displayed, and you can edit them like normal fields. You can only assign input parameters to other input parameters. An input parameter can be compounded either with an InfoObject or with another input parameter.

  5. By choosing Set PartProvider Runtime Properties in the context menu of a participating InfoProvider, you can make the settings for the query properties. More information: Query Properties
  6. You can create groups in order to organize the fields of a CompositeProvider semantically. More information: Editing Groups
  7. By pressing the (Replace) speed button, you can replace one provider with another.
  8. By choosing Check BW objectCheck BW object, you can check whether any assignments are missing.