Assign data sources to Grid
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.
b. Assign BigMemory data source.
c. Assign CSV data source.
d. Assign XML data source.
e. Assign ARIS Table data source.
f. Assign JDBC data source.
6. In addition to the data source operator you can add further operators to transform the source data.
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.
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.