Adding a Data Source to Filter the Metric Data

Data sources provide the data to Dashboard. Data sources are OQL (object query language) queries that execute in dashboard agents. The data source query returns data from instances of the specified metric in the cache (or backing store). You can also filter and sort the data. (TIBCO BusinessEvents Event Stream Processing software is not required.)

You can configure the data source with a parameterized where clause. Dashboard users can then use the Quick Edit feature to specify a metric field value that filters chart data. Depending on the data type, you can use different operators, for example: where Price > $MinPrice. You can set default values for query parameters in the Chart editor’s Chart Data tab, so the chart can display data before users provide parameter values. The tutorial does not demonstrate this feature but you can try it out on your own.

For more information, see TIBCO BusinessEvents Views Developer’s Guide.

Procedure

  1. In TIBCO BusinessEvents Studio Explorer, select the M_TickerTracker metric. Click the New Data Source toolbar button.
  2. You see the New Data Source wizard. Name the data source DS_TickersSortedByPrice and click Next.
  3. In the Query field of the Create New Data Source page, you see this query: 
       select * from /Dashboards/M_TickerTracker;

    Extend the query to add the sorting details as shown:

       select * from /Dashboards/M_TickerTracker order by Price desc;
  4. Click Finish. You see the data source editor showing the configured data source. Details you entered in the wizard are saved automatically.

Result

Postrequisites

Next you will add the event that provides data you enter on the Readme file’s HTML form, and the rule that computes the metric using that data.