Explorer reports

In addition to standard and custom reports, you can use Explorer reports, which are available in the cluster management console.

Explorer reports are available with IBM® Spectrum Symphony Advanced Edition on Linux® and Linux on POWER®. To use Explorer reports, ensure the following requirements:
  1. Install the Elasticsearch, Node.js, and Explorer packages during IBM Spectrum Symphony installation.
  2. Enable the Explorer reports feature.
  3. To view an Explorer dashboard, you must have EXPLORER permission.
  4. To work with Charge Back charts, you do not require special permission; however, to create, edit, or delete other Explorer reports, you must have EXPLORER permission.

Explorer reports, charts, and dashboards

Reports
The term Explorer reports is a larger concept to indicate reporting or communicating data stored in database tables through the Reports & Logs > Explorer Reports option in the cluster management console. IBM Spectrum Symphony also provides standard and custom reports within the console.
Charts
IBM Spectrum Symphony shows the data in the form of Explorer charts, available under Reports & Logs > Explorer Reports > Charts. By default, the charts display data as bar charts; you can also customize charts to display differently (for example, as a pie, area, line, or table chart).

Currently, IBM Spectrum Symphony provides one Explorer report: the Charge Back chart, which calculates the slot charge back amounts for EGO allocated resources over time (hours, days, weeks, or months). Use this chart to help determine charging. The Charge Back chart includes a series of filters, so you can customize your view. This report is for slot based scheduling, not multidimensional based scheduling.

IBM Spectrum Symphony using the charge back rate from the CHARGEBACK_RATE database table, and calculates the data using the CALC_CHARGE_BACK stored procedure, and the ALLOCATION_EVENT_VIEW view.

Dashboards
To see multiple Explorer charts in one view, use an Explorer dashboard. Access dashboards by selecting Reports & Logs > Explorer Reports > Dashboards. All charts in a dashboard share filters. You can create custom dashboards and add charts to each dashboard.

Data loaders for Explorer reports

Like standard and custom reports, Explorer reports also use data loaders from the IBM Spectrum Symphony reporting framework. With Explorer reports, IBM Spectrum Symphony additionally aggregates the data from the reporting framework database, and inserts this aggregated data into Elasticsearch to generate Explorer reports.

For the Charge Back chart, IBM Spectrum Symphony uses the symchargebackloader data loader. This loader is triggered every hour, on the hour. The loader aggregates data from the last time it was run (as recorded in temporary time slot record file $EGO_CONFDIR/../../perf/work/ChargeBackDataLoader.tmp) to the last finished hour. For example, if the loader started at 5:00, and the last time it was run was 3:00, if there were slot allocation events after 4:00, the loader will aggregate data from 3:00 to 4:00. If the temporary time slot record file does not exist (this may be the case if you are running the loader for the first time, or if you have deleted the file after changing the charge back rate), the loader will aggregate the data from the past 14 days to last finished hour, and the data will be inserted or updated into the charge back rate database table.