Dashboards : Configure dashboard components : Assign data sources to dashboard components : Assign data sources to Grid
Assign data sources to Grid
 
Configure thresholds of the Grid component
To display a table in a Grid component you have to assign a relevant data source to the component.
The Grid component requires an Event data source or BigMemory data source.
Procedure
1. Create or open a dashboard in MashZone NextGen Dashboard.
2. Click an inserted Grid component. The relevant properies dialog is displayed.
3. Click the Assign Data icon to edit the data source assignment.
The Edit Data Souce dialog will be displayed. Here you can select a data source and create dynamic Input Parameters. The Data Flow box shows an overview of the data source configuration.
4. Optionally you can create input parameters.
You can define dynamical and reusable input parameters for XML data sources, RAQL queries and ARIS table, see Create Input Parameters.
5. Select a data source operator in the Add a data source area and specify your settings.
a. Assign Event data source.
SeeAssign Event data source for details.
b. Assign BigMemory data source.
See Assign BigMemory data source for details.
c. Assign CSV data source.
See Assign CSV data source for details.
d. Assign XML data source.
See Assign XML data source for details.
e. Assign ARIS Table data source.
See Assign ARIS Table data source for details.
f. Assign JDBC data source.
See Assign JDBC data source for details.
6. In addition to the data source operator you can add further operators to transform the source data.
See Data transformation operators for details.
a. Select an operator, e. g. Change data type, in the Add data operations area. The relevant operator will be displayed.
b. Specify your settings.
c. You can display a preview of the transformed source data of each operator. This enables you to track all data changes step by step. Click the Calculate peview icon of an operator.
7. Click Next.
8. Assign data source columns to grid columns.
You can assign one or more columns of your data source to the Grid component.
a. Insert a Data column in the Grid Colums box via drag and drop.
b. Click a grid column and enter a New Column Name if necessary.
c. Change the Aggregation type if necessary. The aggregation type specifies how the KPI value is calculated. This option is only available for columns of typ numeric.
d. Select a Format in the drop-down menu. This option is only available for columns of typ date and numeric.
e. Activate the Round numerically option to display rounded KPI values in the chart.
f. Activate the Show negative values in red option to display negative KPI values red highlighted.
g. Activate the Show cell value option to display the values of the column.
h. Activate the Make clickable (for actions) option to make the column clickable for triggering actions. See Specify actions for dashboard components for details.
9. Click Edit Data Source to change the source settings.
10. Click OK.
The table will be displayed with real data of the assigned data source.
Copyright © 2013-2016 Software AG, Darmstadt, Germany.

Product LogoContact Support   |   Community   |   Feedback