Show TOC

Creating Union 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 union.


  1. You are on the Scenario tab page.
  2. Select other participating InfoProviders or SAP HANA views.

    To add further objects to the union operation, you have the following options:

    • In the context menu of the union node, choose Add. To find your provider, you can enter the technical name or description as search terms. This will only return providers that you can use in a CompositeProvider.
    • Press (Add).
    • You can use drag & drop to add BW InfoProviders from the Project Explorer to the scenario.

    You cannot use a provider more than once in a union operation. You can use the same provider in a union operation and as the right join partner however.

  3. You can also add further InfoProviders using joins. There are several ways of creating new higher-level joins:
    • Choose Join with in the context menu.
    • Press (Join with).
    • You can use drag & drop to add BW InfoProviders from the Project Explorer to the scenario.

    This adds a join level above the existing operation. A join can only ever be created between two providers.

  4. By pressing the (Replace) speed button, you can replace one provider with another.
  5. In the area on the right of the screen, you can configure the assignments for the fields. On the left, you see the participating providers. To the right of these, the CompositeProvider's fields are displayed.
    The field types are distinguished by their icons:
    • Characteristic:
    • Time characteristic:
    • Unit:
    • Key figure:
    In the graphical display, you can add the fields to the CompositeProvider either using drag and drop or by choosing Create Assignments in the context menu and create the assignments. 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 InfoObjects are added, and the dimensions are added as groups. If a field does not exist yet in the target 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.

    Screenshot:Tab Page Scenario - Graphical
  6. 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
  7. You can create groups in order to organize the fields of a CompositeProvider semantically. More information: Editing Groups
  8. By choosing Check BW objectCheck BW object, you can check whether any assignments are missing.
  9. In the context menu on one of the fields in your CompositeProvider, you can delete the assignments again.