Freeform Dashbording : Configure dashboard components in Presto Freeform : Assign data sources to dashboard components : Assign data sources to Presto Grid
Assign data sources to Presto Grid
To display a table in a Presto Grid component you have to assign a relevant data source to the component.
The Real-time chart component requires an Event data source or BigMemory data source.
Procedure
1. Create or open a dashboard in Presto Freeform.
2. Click an inserted Real-time chart component. The relevant properies dialog is displayed.
3. Click the Configure icon to edit the data source assignment. The Select data souce dialog will be displayed.
4. Select data source.
*Assign Event data source.
i. Click Start with Event data source.
ii. Select an Event Source in the Drop-down menu.
*Assign BigMemory data source
i. Click Start with BigMemory data source.
ii. Enter Cache Alias in the folowing form. See example BigMemory data source.
<configuration name>.<cache name>
iii. Enter a RAQL query. See example BigMemory data source.
You can enter any RAQL statement.
5. In addition to the data source operator you can add an operator to change the data type of the source data.
a. Click the Add icon and select Change data type. The relevant operator will be displayed.
b. Select a Column in the drop-down menu to change the column data type.
c. Click on the Text, Number or Date icon to assign a New Data Typ.
d. Depending on the selected data type you can edit addional settings, e.g. data format. Click the Additional settings icon.
e. Click the Add icon to add columns.
6. In addition you can display the calculated source data of an operator. Click the Calculate peview icon.
7. Assign Data columns to chart axis.
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. Optionally, you can edit the column properties if necessary. Dependig on the column type there are diffrent Options available.
8. Click Edit Source to change the source settings.
9. Click OK.
The table will be displayed with real data of the assigned data source.
BigMemory Data source
To use the RAQL BigMemory operator you have to follow these conventions. The Cache Alias you have to enter is <configuration name>.<cache name>. <configuration name> is the Title you specified as name for the configuration, <cache name> is one of the caches available in the configuration. In this example, the information you would have to enter in the Cache Alias field is "my_caches.data_cache".
In the statement field, you can enter the RAQL statement. If you refer to a cache within the configuration, you just specify the cache name (i. e. without the configuration name). In the above example, if you wanted to address the "data_cache" cache, you would formulate your RAQL statement similar to this:
SELECT description FROM data_cache
Copyright © 2006-2015 Software AG, Darmstadt, Germany.

Product LogoContact Support   |   Community   |   Feedback