Creating a simple Chargeback report

Chargeback reports allow administrators and managers to evaluate capacity usage by application, business entity, service level, and tier. The chargeback reports include capacity accountability, historical capacity accountability, and trending data. The data for these reports are built and scheduled from the OnCommand Insight Data Warehouse.

Before you begin

To create the sample report your system must be configured to report costs for storage tiers. The following tasks need to be completed:

About this task

This example uses the Cognos Workspace Advanced reporting tool to create the Chargeback report. With Workspace Advanced, you create reports by dragging and dropping data elements into a report pallet.

Steps

  1. In the OnCommand Insight web UI, click the reporting icon.
  2. Log in to the Reporting Portal.
  3. In the IBM Cognos Connection toolbar, click Launch > Cognos Worksapce Advanced
    The Workspace Advanced package screen opens.
  4. Click Packages > Chargeback
    The IBM Workspace Advanace screen is displayed.
  5. Click New
  6. In the New report dialog Click List to specify a list report.
    The report palette is displayed and the Chargeback "Simple data mart" and "Advanced data mart" are displayed under the Source heading.
  7. Click the arrows next to each data mart to expand them.
    The full contents of the data marts are displayed.
  8. Drag "Application" from the "Simple Data Mart " into the far left column of the report palette.
    When you drag an item into the palette the column shrinks and is highlighted. Dropping the application data into the highlighted columns results in all of the applications being listed correctly in the column.
  9. Drag "Tier" from the "Simple Data Mart " into the next column of the report palette.
    The storage tier associated with each application is added to the palette.
  10. Drag "Tier Cost" from the "Simple Data Mart " into the next column of the report palette.
  11. Drag "Provisioned capacity" from the "Simple Data Mart " into the next column of the report palette.
  12. Hold down the Ctrl key and select the "Tier cost" and "Provisioned capacity" columns in the pallet.
  13. Right-click the mouse in either of the selected columns.
  14. Click Calculate > Tier cost * Provisioned capacity DB
    A new column is added to the pallet with the title "Tier Cost * Provision Capacity GB".
  15. Right click the Tier Cost * Provision Capacity GB column.
  16. Click Style > Data Type
  17. Click Format type > Currency
  18. Click OK
    The column data is now formatted as US currency.
  19. Right click "Tier Cost * Provision Capacity GB" and select Edit Data Item Label
  20. Replace the Name field with "Provisioned Capacity Cost"
  21. To run the report, click Run > Run report - HTML
    A report similar to the following is displayed.