How to: |
The Infoset Editor can be used to relate, aggregate, and format real-time event data within a business space. A business analyst identifies or discovers events to be related because they directly or indirectly affect one another. Event relationships only exist in the Infoset and are not globally known in iWay Enable. The Infoset Editor assists with aggregating and formatting an Infoset so that it can be used to create feeds.
To create an Infoset:
The iWay Service Manager Tools pane opens.
The Views pane opens, as shown in the following image.
The contents of the Infoset tab are displayed, as shown in the following image.
A quick Infoset is created that will represent all of the events containing the sales.quantity string in its name, as shown in the following image.
You can now edit this Infoset according to your requirements. For example, if you are only interested in the sum of products sold, you can delete all the other columns besides sum (count, avg, min, max, and last).
This multiple cell selecting functionality is similar to how it can be performed in other spreadsheet applications, such as Microsoft Excel.
Only a single column (sum) now remains, which indicates the quantity sold for each product, as shown in the following image.
You can further modify this Infoset by formatting the event column to only include the product name without the sales.quantity prefix.
To format the entire column, right-click the event column name and select Format Column from the context menu.
The Edit iFL Expression dialog box opens, which allows you to provide a formatting instruction for the selected column.
The formatting can be performed using any of the supported IFL statements. In this case you are examining the string which comes after the “sales.quantity.”. The $ character indicates the current cell. As a result, the expression _after($,'sales.quantity.') will produce the required result. It will rename products to product1, product2, and product3.
_after($,'sales.quantity.')
Notice that the products are now renamed accordingly.
The next step will be to copy the content of column C into the content of column B, since an empty column has no significance. You will need to associate the product name with the sold quantity. The first column is used as an event identifier, and the next column is used to store the values. As a result, you must move column C, which holds the proper content, to column B.
The resulting Infoset will have two columns. The event column represents the name of the event and the Sum column represents the quantity sold.
The Save Infoset dialog box opens.
An Infoset can also be used to generate a JSON (JavaScript Object Notation) feed. The feed can then be used by any of the supported iWay Enable gauges, charts, and grids.
To create a feed from an Infoset:
The Create Table Feed dialog box opens.
You can also sum up the individual product sales to generate a total sale. This can be done by using the summation option from the toolbar or by typing in the actual expression into a cell. To use the sum option from the toolbar, highlight the cells to add and include an additional blank cell at the bottom where the summation will be stored.
A total quantity is now displayed and the associated iFL expression can be viewed in the iFL expression bar, as shown in the following image.
As any cell within the Infoset can be used as a standalone feed, you can save this cell as a feed to be used in a supported gauge configuration.
The Create Feed dialog box opens.
To configure a chart resource with a JSON feed:
The iWay Service Manager Tools pane opens.
The Resources pane opens and displays the Gauges tab by default, as shown in the following image.
The Charts tab opens and displays the available charts that can be configured, as shown in the following image.
The second page of the available charts opens, as shown in the following image.
Initially, no data is displayed since there is no associated feed.
The Pie Chart is now updated with the current information. You can move your cursor over the chart to see the details.
The Save as Portlet dialog box opens.
You are returned to the Portlets tab where you can run the new portlet that you just configured.
Data is updated dynamically in the Pie Chart portlet, as shown in the following image.
To configure a gauge resource with a JSON feed:
The iWay Service Manager Tools pane opens.
The Resources pane opens and displays the Gauges tab by default, as shown in the following image.
A listing of all the available Bulb type gauges opens, as shown in the following image.
Initially, no data is displayed since there is no associated feed.
The Bulb Gauge is now updated with the current information. You can move your cursor over the chart to see the details.
The Save as Portlet dialog box opens.
You are returned to the Portlets tab where you can run the new portlet that you just configured.
Data is updated dynamically in the Bulb Gauge portlet, as shown in the following image.
iWay Software |