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

 

 

 

If you have the Manage Personal Reports or Manage Shared Reports permission, you can create reports.

For more information about granting permissions, see Permissions.

Creating reports

To create a report

  1. In the Navigation pane, click Reports (if you're already on the Reports page in your default view, you can skip to step 2).
    The Reports page lists the default reports (lock icon) and your user reports (user icon):
    CAP_reports_fig1.png

  2. Click the + icon in the upper right hand corner.
    The Create New Report page displays, showing the report configuration panel.
    CAP_reports_fig2_create.png

  3. Select the desired date range from the selection list:
    • Yesterday
    • The current or previous month, quarter or year
    • The previous 7, 14, 30, 60 or 90 days
    • The previous 12 or 13 months
    • A custom date range

    If you select dates manually from the calendars in the from and to fields, custom date range is automatically selected.

  4. In the Fields list, click the checkbox next to each field you want to include as a column in the report.  
    You can use the selection 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).
    • An administrator might have hidden some fields, such as tags and fields used in SmartTags rules. To display/hide fields, toggle the eye icon.
    • You can mouse over a field name and click the information icon 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.
    • You can add no more than 10 string based (text) columns to a report.
    • To remove a column from your report, you can either uncheck the field in the Fields list, or right-click it in the Columns list and click Remove Field.

    As you add fields to the Columns list, they appear as columns in the report display, and the report updates to include a row for each unique combination of data.  For example, you might add the Service Category, Provider, Meter Name, and Cost fields to your report:
    CAP_reports_fig2a_create_columns.png

  5. If you want the report to include an aggregate summary for a field, select one of the aggregation options for the field from the pulldown in the Columns list:
    Aggregation option Description
    Do Not Aggregate

    If you select this option, the report does not summarize data for this column.  Each row for this column includes a raw value from the database.

    Sum

    If you select this option, 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 this option for the Cost column, the Cost column shows the cumulative cost for each provider and product.

    Maximum

    If you select this option, 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 this option for the Rate column, the Rate column shows the maximum rate for each provider and product.

    Minimum

    If you select this option, rows for this column show the lowest value available. This option is available only for number fields.

    Average

    If you select this option, rows for this column show the average of the values available. This option is available only for number fields.

    Count (Not Blanks)

    If you select this option, 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 Account ID columns, and you select this option for the Provider column, the Provider column shows the raw number of its matching values for each unique row of product and account ID. 

    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 Account ID columns, and you select this option for the Provider column, the Provider column shows the number of its unique matching values for each unique row of product and account ID. 

  6. 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 list. For example, if you want to group report data by service category, drag the Service Category field to the Groups list:
    CAP_reports_fig2b_create_group.png

    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.

  7. If you want to organize aggregated data as sub-columns of another column (the pivot field), drag the field from the Columns list to the Pivot Field box, .
    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 Cost Center field to the Pivot Field box, HPE Consumption Analytics Portal adds a super-column for each Cost Center value, with aggregated Cost columns beneath it. 
    CAP_reports_fig2d_create_pivot_field.png
    • When using a pivot field, a report will display no more than 25 columns of data.
    • The pivot field cannot be a field that is marked for aggregation, or a field that is used for grouping.
    • 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, an error message will display:
      CAP_reports_fig2d_create_pivot_field_error.png

  8. 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 the desired field(s) to the Filters list.
  9. Define the filter in the Filter Manager popup:
    CAP_reports_fig2c_create_filter.png

    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.


  10. Click Save to close the Filter Manager.  The filtered results display:
    CAP_reports_fig2d_create_filtered.png

  11. Save the report:
    1. Click the Save icon.
      The Save Report dialog box displays:
      CAP_reports_fig2f_create_save.png

    2. Enter a Report Name and a Report Description
    3. If you have the Manage Shared Reports permission and want to share the report, click Share With All Users, then 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.
      Your report is now available in the Report selection list in the Reports page of your default view.:CAP_reports_fig7_default_view_sel.png

      You can also select Reports in the left navigation to view and maintain it:
      CAP_reports_fig3_saved.png 
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 permission 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.

Last modified

Tags

Classifications

This page has no classifications.

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