Show TOC

Procedure documentationConfiguring the Main Model Elements Locate this document in the navigation structure

 

In this example, you integrate a query based on an SAP BI data service into your model, output the results into a table, and attach an input form to the query.

Prerequisites

As outlined in Integrating Value Help into Your Model

Procedure

  1. Create the model and name it appropriately, such as ValueHelp.

  2. Create an iView (dragging the iView icon from the Compose Model task panel) and call it Order and Sales Values: Select Sales Organization. Drill down into the iView.

  3. Integrate the query into your model:

    1. On the Find Data Services task panel, from the System drop-down list, select the data service that contains the BI system in which the demo InfoCube is activated.

    2. From the Look for drop-down list, select Look for a query.

    3. In the Query field, enter the technical name of the query: 0D_SD_C03_Q009, and click Search.

    4. Select the query Order and sales values (0D_SD_C03_Q009) and drag it onto the workspace.

      The metadata from the query is retrieved and integrated into your model:

      Retrieving the Metadata (Retrieving the Metadata)

  4. Create an input form for the query so that the user can specify a distribution channel:

    1. Drag from query's Input port and choose Add Input Form from the context menu.

    2. You want to only display the sales organization and a submit button in the form, so double-click the input form to display the Configure Element task panel. In the first column of the table at the bottom, click the checkmarks to deselect all fields except Sales_organization and SUBMIT:

      Deselect Fields (Deselect Fields)

  5. Output the query results into a table:

    1. In the workspace, drag from query's Output port and choose Add Table View from the context menu. The Select Display Fields dialog box is displayed.

    2. To configure the table to display the incoming orders value and sold-to party fields, select Incoming_orders_value and Sold_to_party.

  6. Save the model.

Result

You have created an iView that outputs the results of a BI query into a table, and you have attached an input form in which the user can specify the sales organization. The model should look similar to the following:

Value Help - Design (Value Help - Design)

You are now ready to proceed to Adding and Configuring Value Help.