Using Advanced Reports

Overview

Reports are a very powerful and flexible feature of Capacity Planner. Among other features, they allow you to:

  • Summarise utilisation over any time period that has been modelled for a group of entities.
  • Create RAG reports indicating where any breaches may have occurred.
  • Analyse relationships between metrics and check how many inactive VMs you have.

Most reports also provide a drill-through capability to view data at successively lower levels of granularity. They can be run against different entity types (for example, physical servers, virtual machines, or hosts). Reports have configurable parameters to provide maximum flexibility.

Reports can be accessed from the Reporting accordion on the Capacity Planner project home screen.

For a full list of reports available in Capacity Planner, see Available Reports.

Note: It is important to distinguish these advanced reporting features of Capacity Planner from the Infrastructure, Service and Scenario reports that can be created directly from the Baseline View and Forward Thinking scenario model. To learn more about them, see Infrastructure and Service Reports and Scenario Reports.

Interface

The report screen is divided into the following sections:

  • Report parameters — parameters are used to filter the data that you want to see in your report as well as select report formatting and display options. Most reports require parameters to be input here. For more information, see Report Parameters.
  • Report toolbar — provides additional actions for the report. It only appears once the report is generated. The available actions are:
    • Going to the first, previous, next and last page of the report.
    • Going back to the parent report.
    • Searching for specific text appearing in the report.
    • Exporting the report.
    • Refreshing the report
  • Report view — where the report appears. To expand the view of the report, click the Show/Hide Parameters button right above the report toolbar. This is particularly helpful with reports that have a large number of parameters.

Generate a report

Most reports require parameters to be entered before they can be run. Some parameters have default values that you can change. Reports that only have default parameters run as soon as you open the report. Most reports require additional parameters to be entered, although default values are provided for parameters that tend to be changed less often.

To generate a report, provide the required parameters and click the View Report button. Different reports require different parameters. For more information, see Report Parameters.

Pagination

When a report is generated on screen, only the first page of a report is generated to reduce processing time. If there is more than one page, a question mark ? is displayed after the total number of pages indicating the length of the report is unknown. Use the Previous/Next Page and First/Last Page buttons to move between pages.

When you move to the final page of a report, the total page count is displayed on the toolbar and the question mark is removed.

Exporting a report automatically exports all pages.

Export a report

You can export a report in one of several file formats. This allows you to share the report output with anyone without direct access to Capacity Planner.

Note: Reports use a variety of layouts and styles. Not every export format works well with every report, and pagination may differ from the on-screen version of the report.

The available export formats are:

  • Word
  • Excel
  • PowerPoint
  • PDF
  • TIFF file
  • MHTML (web archive)
  • CSV (comma delimited)
  • XML with report data
  • Data feed

To export a report, click the export icon in the report toolbar and select the format from the drop-down list.

Your browser initiates a download of the file.

Drill-through reports

In most reports, you can drill through to view data at lower levels of granularity. The drill through mechanism shows the next summary level, for example drilling down from monthly summaries takes you to daily summaries. In most cases, it is possible to drill through to the lowest level of granularity (normally 5-minutely data). If there is no data with available with lower level of granularity, you will not be able to drill through any further.

Every time you drill through, a new report is generated that displays data at a lower level of granularity. If you export this data, you get the lower lever grain in your export.

To go back to the main view of the report, click the Go back to the parent report button in the report toolbar.

Search the report

You can search the text of a report using the search field in the report toolbar. You can type in a name of the VM, a number, or any other text that can appear in any place of the report. This is especially useful if a report is very long and has multiple pages.

Add a new report

If you require a custom report to be added to your project, please contact your Capacity Planner representative.