Cloud Cruiser became HPE Consumption Analytics on Nov. 1, 2018. You'll still see the old name in places while we update this site.



Consumption Analytics Documentation

Home > HPE Consumption Analytics Portal Documentation > Configuring the HPE Consumption Analytics Portal > Creating Reports

Creating Reports

This article is part of Configuring the HPE Consumption Analytics Portal

4. Create



Reports run against the usage and charge data you collect. Reports are highly customizable. You decide what fields to include, how to organize those fields, and how to filter the data to include only what you need in the report. For example, you might want to see all charges, grouped by account, but only for the North America region. You can also pivot your data, much like you can in Microsoft Excel.

If you have the Manage Personal Reports or Manage Shared Reports permission, you can create reports. Sharing reports and editing shared reports requires the Manage Shared Reports permission. Also, if you have the Manage Shared Reports permission you can distribute reports through email to selected users and groups.

If you have the Manage Views permission you can decide which users or groups of users can see each report in their views, through either the Report Details page or the Report widget. For more information about views, see Views.

For more information about granting permissions, see Permissions.

Video overview

The following video helps you understand reports and how they are organized within HPE Consumption Analytics Portal:

Creating reports

To create a report

  1. In the Navigation pane, click Reports.
    The Reports page shows all of your existing reports.
  2. Click the Add icon ReportAdd_icon.png.
    The Create New Report window appears, with the Report Configuration panel visible.

    During editing, if you want a wider view of your report, click the View mode icon () to hide the Report Configuration panel. To open the panel again, click the Edit mode icon ().
  3. In the Fields list, click the checkbox next to each field you want to include as a column in the report.
    As you add fields, they appear as columns in the report display, and in the Columns list. The report also updates to include a row for every unique combination of data as you add columns. To remove a column from your report, uncheck the field in the Fields list. You can add no more than 10 columns to a report.

    Mouse over a field name and click the information icon (ReportInformation_icon.png) to open a Detail dialog box that displays the field's type, the collections that use the field, and a sample of actual data for that field. This information can help you identify which fields should be included in your report.

    Ad administrator might have hidden some fields, such as tags and fields used in SmartTags rules. To see those fields, click the Show Hidden Fields icon (). HPE Consumption Analytics Portal lists hidden fields in italics.

    Use the drop-down list at the top of the Fields list to select a field package that limits which fields are listed. Field packages organize fields for convenience, and might include other groups of fields. For example, the All Fields package includes the Billing Fields and Utilization Fields groups. For more information about fields and field packages, see Fields and field packages.

    For example, you might add the Account Owner, AccountingDate, Cost, Provider Region, and Department Name fields to your report.

  4. (optional) If you want the report to include an aggregate summary for a field, click that field in the Columns list, and then select one of the aggregation options for that field.
    Aggregation option Description
    Do Not Aggregate

    The report does not summarize data for this field. Each row for this column includes a raw value from the database.


    Rows for this column show the sum of the data available. This option is available only for number fields.

    For example, if your report includes the Provider, Product, and Cost columns, and you select the Sum aggregation option for the Cost column, the Cost column shows the cumulative cost for each Provider and Product.


    Rows for this column show the highest value available. This option is available only for number fields.

    For example, if your report includes the Provider, Product, and Rate columns, and you select the Maximum aggregation option for the Rate column, the Rate column shows the maximum rate for each Provider and Product.


    Rows for this column show the lowest value available. This option is available only for number fields.


    Rows for this column show the average of the values available. This option is available only for number fields.

    Count (Not Blanks)

    Rows for this column show the raw number of values matching the unique combinations of the other columns in the report. These matching values might not be unique. The number can be very large, since there might be many non-unique rows for this column that match the unique combinations of other columns in the report.

    For example, If your report includes the Provider, Product, and AccountId columns, and you select the Count (Not Blanks) aggregation option for the Provider column, the Provider column shows the raw number of its matching values for each unique row of Product and AccountId.

    Count (Distinct)

    Rows for this column show the number of unique values matching the unique combinations of the other columns in the report.

    For example, If your report includes the Provider, Product, and AccountId columns, and you select the Count (Distinct) aggregation option for the Provider column, the Provider column shows the number of its unique matching values for each unique row of Product and AccountId.

  5. (Optional) If you want to group your rows by any field, drag that field to the Groups list. 
    A Group column is added to your report, with a row for each unique value for the field you selected. If you group by more than one field, groupings are nested according to the order in the Groups list. For example, if you want to group report data by departments, drag the Department Name field to the Groups list.

    If you group data in a report, and a row of data is missing a value for that group field, that row is grouped in the (no value) group.
  6. (Optional) If you want to organize aggregated data as sub-columns of another column (the pivot field), drag that pivot field from the Columns list to the Pivot Field box, and then select a Pivot Interval for that field.
    A new super-column is added for each value of the pivot field, with sub-columns for each aggregated field in the Columns list. For example, if you drag the AccountingDate field to the Pivot Field box and select an interval of Month, HPE Consumption Analytics Portal adds a super-column for each AccountingDate value, with monthly-aggregated Cost columns within each super-column.  Note the available intervals are Day, Week, Month, Quarter, and Year. If you select an interval of Week, the week starts on Monday and ends on Sunday. 

    When using a pivot field, a report will display no more than 25 columns of data.

    Ensure that you have at least one aggregated field in the Columns list before dragging a field to the Pivot Field box. If you try to pivot on a field, and you have no aggregated fields on which to pivot, the report will remain in the state of trying to update. If your report enters this state, refresh your browser.

    The pivot field cannot be a field that is marked for aggregation, or a field that is used for grouping.

  7. (optional) If you want to set a default date range for the data to show in the report, use the date range fields above the table to select the range.
    The date range you select will be used when users open the report in their Views. For more information about filtering data by date, see Adjusting the date range.
  8. (optional) If you want to filter your report to include only a subset of data for the columns you selected, add one or more filters by dragging a field to to Filters area.
    Any filters you define as part of the report are saved with the report. If you share the report with other users (as described in the next step), they can add their own filters but they cannot remove the filters you defined with the report. For more information about defining filters, see Filtering data.
  9. Save the report:
    1. Click the Save icon ().
      The Save Report dialog box appears.
    2. Enter a Report Name and a Report Description.
    3. If you have the Manage Shared Reports permission, in the Share With field select one or more users or groups that will have permission to use this report. If you want all users to use this report, select Share With All Users. For more information about managing users and groups, see Users and groups.
    4. Click Save.
Video example

The following video shows you how to create and edit shared reports, enabling you and others in your organization to see your cloud usage and cost information. You must have the Manage Shared Reports capability to do this.

What to do after creating reports

Create insight rules that alert you by email about situations in your cloud that are either costing you money or harming your environment in some other way. For more information, see Insights.

Copying reports

If you want to create a report based on an existing report, you can make a copy.

To copy a report

  1. On the Reports page, click the gear icon (ReportGear_icon.png) next to the report you want to copy, and then select Copy.
    A copy of the report opens in the report editor.
  2. Alter the report as you like, and then click the Save icon (reportsSave_icon.jpg). Be sure to give the report a new name and description.
    For more information about creating reports, see the Creating reports procedure.

Distributing reports in email

You can distribute any report by email to Cloud Cruiser users and groups.

To distribute a report in email

  1. Open the Report Distribution dialog box using one of the following methods:
    • From the Reports list, click the gear icon (ReportGear_icon.png) next to a report and select Toggle Distribution.
    • Open a report, and then click the Email icon ().
  2. Set the Distribution toggle to Active.
  3. In the Distribution Frequency field, select how often to email the report.
  4. Depending on the frequency you selected, use one or more of the On Day, On Hour, and On Minute fields to specify exactly when the report is sent.
  5. In the Time Period field, select the range of data to use in the report.
    This range is relative to the frequency you selected. For example, if you schedule Weekly distribution of the report, and you select a Time Period of Last 30 Days, the first report sent includes 30 days of new data. The next time the report is sent, it includes 23 days of data that was included in the previous report, plus 7 days of new data.
  6. In the Send To field, select one or more users or groups to receive this report.
    The report must also be shared with these users and groups for them to receive its distribution.
    After you select them from the list, they are added to the Shared with Whom? field.
  7. In the Email Subject field, enter a subject line for the email.
  8. In the Email Body field, enter the text to include in the body of the email.
  9. In the Export Format field, select the report file type attached to the email.
  10. When you are done scheduling email distribution for the report, click Save.
    Users will receive the report by email. For example:
Video example

The following video shows you how to schedule reports for email distribution:

Editing report distribution from the Reports page

If you want to change only the distribution of a report, you can do so directly from th Reports page.

To edit the distribution of a report

  1. On the Reports page, click the gear icon (ReportGear_icon.png) next to the report for which you want to change distriubution, and then select Toggle Distribution.
    The Report Distribution dialog box opens.
  2. Alter the distribution report as you like, and then click Save.
    For more information about distributing reports, see the Distributing reports in email procedure.
Last modified



This page has no classifications.

 (c) Copyright 2017-2020 Hewlett Packard Enterprise Development LP