Show TOC

Function documentationTransform Real Time Data from SAP MII to SAP Business Objects Dashboard Locate this document in the navigation structure

 

You use the dashboard connector to receive real-time data from SAP MII and create customized dashboards.

Features

You can select a query from SAP MII, link the results from the query to the embedded spreadsheet, and create a dashboard. You can also integrate the SAP MII Plant Information Catalog with the dashboard. You can browse the Plant Information Catalog and, select the tags and groups to be displayed.

The user interface of the dashboard connector contains the following tab areas:

  • Definition

    In this tab page, you can do the following:

    • Select the SAP MII server you want to use as data source by entering the SAP MII server’s hostname, port, and logon credentials.

    • Verify the connection to the SAP MII server by choosing Test Connection.

    • Choose Browse… to select the query template from which the data must be loaded.

    • Bind the result to the spreadsheet by selecting the output parameter and a spreadsheet range.

    • Verify the output response from the SAP MII system by choosing Preview XML.

    • Choose the mode of execution. The default mode is Execute Query Template. Here, you browse, select a query, and bind the parameters to a spreadsheet. On choosing Execute Catalog Object, you can browse for tags and groups from the Plant Information Catalog at design time.

  • Catalog

    On selecting Execute Catalog Object as the mode of execution, you can do the following:

    • Store the tags available in the tag catalog to the parameters in the spread sheet. Choose the tags from the Catalog pane and add it to the Selected Namespace pane. Alternatively, you can pass the tag names from the spreadsheet to the connector by binding a row in the Selected Namespace pane to a cell in the spreadsheet. To do this, select a row in the Selected Namespace pane and choose Cell Selector. Select a cell in the spreadsheet and choose OK.

    • Remove the selected tags or the bindings by selecting a row in the Selected Namespace pane and move it back to the Catalog pane.

    • View the properties of the selected tag

  • Usage

    In this tab page, you can configure the connection to set refresh and message options. You can do the following:

    • Set the refresh options from the Refresh Options tab.

      To preview the connections in the dashboard, choose Refresh on Load.

    • In the Load Status tab page, you define messages to display when the dashboard is loading or idle.

    • Specify whether the cursor is available during loading

    • Specify whether mouse input is available.

  • Advanced

    In this tab, you can use SAP MII’s query parameters and provide parameter values dynamically. This allows full flexibility of SAP MII query parameters to create a whole set of queries by just changing an input parameter. When the parameterized query is executed, the new values overrides the existing values of the query.

    You can enter the values to the parameters manually in the Parameter Value column or bind any parameter to a cell value in the embedded spreadsheet by choosing Bind Input Parameters cell selector. A tool tip with precise data type appears for each parameter.

Activities

To create a dashboard from the embedded spreadsheet and to display the tags and groups from the Plant Information Catalog, do the following:

  1. In the Dashboard 4.1 application, choose   Data   Connections.  

  2. Choose Add and select MII Connector from Add-On Connections.

    The Data Manager screen appears.

  3. Enter the connection details in the Definition tab.

  4. Choose any option in the Execution Mode field.

  5. Choose Execute Catalog Object to access the Catalog tab.

  6. On the Catalog tab, select a tag from the Catalog pane. You can either add the tag or bind a cell to the Selected Namespace pane.

    Note Note

    You can also bind the parameters using Bind Input Parameter field.

    End of the note.

  7. To view the properties of the selected tag, select Retrieve Properties.

    The Available Properties and Selected Properties tables appear.

  8. Select the properties from the Available Properties and choose Add.

    The selected properties are now available in the Selected Properties table.

  9. Choose Execute Query Template to browse and select a query in the File Path field.

    The File Browser screen showing all the projects available in SAP MII appears.

  10. To bind the parameters to a spreadsheet, select a parameter from the Output Parameter field and choose .

    The Select a Range text box appears. You can select the parameters required for each row or column.

  11. On the Usage tab, select any one option from Refresh Options.

  12. Enter appropriate messages in Loading Message and Idle Message fields.

  13. On the Advanced tab, you can choose the parameters from the Input Parameters column.

  14. Double click to edit the input parameter’s value.

  15. Choose bind to the spreadsheet.

  16. You can enter values in the Parameter Value column.