Using Infosets

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.


Top of page

x
Procedure: How to Create an Infoset

To create an Infoset:

  1. Click Tools in the top pane of the iWay Service Manager Administration Console.

    The iWay Service Manager Tools pane opens.

  2. In the left pane, select Views under the Real-time section.

    The Views pane opens, as shown in the following image.

  3. Click the Infoset tab.

    The contents of the Infoset tab are displayed, as shown in the following image.

  4. Create a quick Infoset for Sales of Products by typing sales.quantity as a filter and clicking on the star icon, 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).

  5. Highlight the area for the avg, min, max, and last statistics by selecting the D1 cell and then clicking on the G4 cell while holding the Shift key.

    This multiple cell selecting functionality is similar to how it can be performed in other spreadsheet applications, such as Microsoft Excel.

  6. Press the Delete key while the selection is highlighted.
  7. Delete the count column by using the same technique that is described in step 5.

    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.

  8. Input the iFL statement as follows:
    _after($,'sales.quantity.')
  9. Click Save.

    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.

  10. Highlight the four cells of interest in column C by clicking the cells and holding the Shift key.

  11. Press Ctr+C on your keyboard to copy the selection.
  12. Highlight the corresponding section in column B, as shown in the following image.

  13. Press Ctr+V to paste the selection in column B.

  14. Delete the content from column C by highlighting the values and pressing Delete.

    The resulting Infoset will have two columns. The event column represents the name of the event and the Sum column represents the quantity sold.

  15. Save the Infoset by clicking the blue disk icon on the toolbar.

    The Save Infoset dialog box opens.

  16. Provide a name for the Infoset (for example, SalesInfoset) and click save.

Top of page

x
Procedure: How to Create a JSON Feed From an Infoset

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:

  1. Click the orange icon (save table as feed) on the toolbar of the Infoset Editor, as shown in the following image.

    The Create Table Feed dialog box opens.

  2. Provide a name for the feed (for example, SalesTableFeed) and click save.

    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.

  3. Click the sum icon on the toolbar.

    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.

  4. To save a cell as a feed, select the cell and click on the green icon on the toolbar (save cell as a feed) of the Infoset Editor, as shown in the following image.

    The Create Feed dialog box opens.

  5. Provide a name for the feed (for example, SalesTotalQuantity) and click save.

Top of page

x
Procedure: How to Configure a Chart Resource With a JSON Feed

To configure a chart resource with a JSON feed:

  1. Click Tools in the top pane of the iWay Service Manager Administration Console.

    The iWay Service Manager Tools pane opens.

  2. In the left pane, select Resources under the Real-time section.

    The Resources pane opens and displays the Gauges tab by default, as shown in the following image.

  3. Click the Charts tab.

    The Charts tab opens and displays the available charts that can be configured, as shown in the following image.

  4. Navigate to the second page of the available charts by clicking page number 2 or Next.

    The second page of the available charts opens, as shown in the following image.

  5. Select the Pie Chart type.

    Initially, no data is displayed since there is no associated feed.

  6. Select enable.SalesTableFeed from the Feed drop-down list, which you generated earlier from the Infoset.

    The Pie Chart is now updated with the current information. You can move your cursor over the chart to see the details.

  7. Type 2 in the interval field, which indicates a two second update interval.

  8. Click Save.

    The Save as Portlet dialog box opens.

  9. Provide a name for the portlet (for example, ProductPieChart) and click OK.

    You are returned to the Portlets tab where you can run the new portlet that you just configured.

  10. Double-click on the portlet (for example, ProductPieChart) to view.
  11. Copy a new document into the input folder that is configured for this application.

    Data is updated dynamically in the Pie Chart portlet, as shown in the following image.


Top of page

x
Procedure: How to Configure a Gauge Resource With a JSON Feed

To configure a gauge resource with a JSON feed:

  1. Click Tools in the top pane of the iWay Service Manager Administration Console.

    The iWay Service Manager Tools pane opens.

  2. In the left pane, select Resources under the Real-time section.

    The Resources pane opens and displays the Gauges tab by default, as shown in the following image.

  3. Click the Bulb gauge.

    A listing of all the available Bulb type gauges opens, as shown in the following image.

  4. Select the first Bulb Gauge (Bulb 1).

    Initially, no data is displayed since there is no associated feed.

  5. Select enable.SalesTotalQuantity from the Feed drop-down list, which you generated earlier from the Infoset.

    The Bulb Gauge is now updated with the current information. You can move your cursor over the chart to see the details.

  6. Type 2 in the interval field, which indicates a two second update interval.

  7. Click Save.

    The Save as Portlet dialog box opens.

  8. Provide a name for the portlet (for example, ProductsTotal) and click OK.

    You are returned to the Portlets tab where you can run the new portlet that you just configured.

  9. Double-click on the portlet (for example, ProductsTotal) to view.
  10. Copy a new document into the input folder that is configured for this application to process another transaction and the portlet will reflect the new value.

    Data is updated dynamically in the Bulb Gauge portlet, as shown in the following image.


iWay Software