Overview

Business Transaction Management provides the following elements to help you create reports:

  • the retrieveObjectData command, which produces the data that you want to use in your report. You specify the data you are interested in using command parameters. For example, you could extract data about fault count by service, maximum response time by transaction, condition alert rate by transaction, and so on.

  • templates that you can use with the Oracle BI Publisher (11 g) application to create well-formatted reports in HTML, PDF, RTF, Excel, PowerPoint, MHTML, and Data formats.

  • sample retrieveObjectData commands that you can use for the type of report you want to generate.

  • sample retrieveObjectData output files that you can use to experiment with your reporting tool without having to generate data.

Material to help you create reports is found in the following directory:

BTM_Install_Directory\samples\reports

The directory includes two sub-directories:

  • templates: this directory includes templates you can use only with the template tools provided by the Oracle BI Publisher (11 g) application. It also includes the reports.xls file, an Excel spreadsheet that shows, for each template, the appropriate retrieveObjectData command that will provide the output data to be combined with the template to generate the report.

    For example, the retrieveObjectData command to be used with the AvgResponseTimeByService template is

    btmcli retrieveObjectData -s sphere -l sphereLogin -type service 
     -attributeNames  friendlyName averageResponseTime -inTheLast 24h 
     -intervalSize 1h -format xmltable > AvgResponseTimeByService.xml

    Or, the retrieveObjectData command to be used with the FaultCountByService template is

    btmcli retrieveObjectData -s sphere -l sphereLogin -type service
     -attributeNames friendlyName faultCount -inTheLast 24h -intervalSize 1h
     -format xmltable > FaultCountByService.xml

  • sampleData: this directory contains sample retrieveObjectData output files that you can use to see what reports might look like without having to generate data.