Assign data sources

Before you can display content in a dashboard component, you must first assign a data source to this component. You can select PPM as data source or any desired data source available in MashZone NextGen.

Procedure

  1. Click the component an the dashboard. The relevant properties dialog is displayed.
  2. Click assign data Assign data to edit the data source assignment. The Assign data (1/2) dialog is displayed.

    Here you can select a data source and specify your data source settings.

  3. Click Next.
  4. The Assign data (2/2) dialog will be displayed.

    Here you can assign the data source columns to the individual widget elements. The function flow diagram requires respectively a column for the Start function, End function and the Relevance value. Additionally, you can define further connection values in the optional list field Additional connection values. These values are available in the settings menu in the function flow diagram and the value order corresponds to the order in the list field. The fields Function names and Function measure value are used to display function measures in the function flow diagram.

  5. Click the assigned columns to specify the columns settings.

    You can change the Display name and the Format of the relevance and connection values. By changing the Sorting of the relevance column you can set the assessment of the connections. By selecting Ascending, high values are considered positive (for example, revenue), or by selecting Descending, low values are considered positive (for example, costs).

  6. Click OK to save your settings.

The widget shows a function flow diagram based on the data of the assigned data source.

Option list

Field

Description

Start function

Contains the column of the start nodes. These nodes are used as a starting point for the connections and a connection is drawn to the end node.

Mandatory,

Text columns only,

If the field is empty, no graph is displayed.

End function

Contains the column of the end nodes. These nodes are used as a target point for the connections and a connection is drawn from the start node to the end node.

Mandatory,

Text columns only,

If the field is empty, no graph is displayed.

Relevance value

Contains the column of the relevance values. The relevance value calculates the thickness of the connections, if enabled. The sorting of the relevance can be changed via a property.

Mandatory,

Numeric columns only,

If the field is not filled, no graph is shown.

Additional connection values

Can be used to define additional values that can be displayed on connections. The order determines the order in the later selection box. The box can be used to switch between these values.

Optional,

Numeric columns only.

Function names

Contains the column of all function names. It has to be a column other than the start or end function because the start function misses nodes without outgoing connections & end function misses nodes without incoming connections and therefore not all required function names are contained in these columns.

Optional,

Text columns only,

It is used to display function measures.

Function measure value

Contains the column of the function measure values. The data of the column is displayed as a function measure within the function boxes. It is only possible to display one value for the function measure.

Optional,

Numeric columns only,

It is used to display function measures.