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

 

 

Consumption Analytics Documentation

Home > HPE Consumption Analytics Portal > Configuring the HPE Consumption Analytics Portal > Fields and field packages

Fields and field packages

Fields are the dimensions, measures, and tags you have collected or created in HPE Consumption Analytics Portal. Most of the fields on the Fields page are added by your collections, though you can also create fields directly from the Fields page, or as part of rule actions.

HPE Consumption Analytics Portal categorizes fields by their type, as follows:

  • System: Fields that represent usage and billing data collected from your source, such as Azure and AWS. You cannot delete System fields from HPE Consumption Analytics Portal.
  • Fixed: Fields that exist as tags on your source, plus some provider fields that do not have equivalent fields from other providers (such as the Azure Meter Category and Meter Sub-Category fields). You cannot delete Fixed fields from HPE Consumption Analytics Portal.
  • Custom: Fields created by you in HPE Consumption Analytics Portal.

You can delete Fixed and Custom fields if they are not used elsewhere in HPE Consumption Analytics Portal. For example, if you use a Custom field in a filter and a chart, you will be unable to delete that field until it is no longer used by the filter and chart.

You might have several fields in HPE Consumption Analytics Portal, especially if you have multiple collections for different cloud providers. To make it easier for you to find fields you have collected, use the Group icon () to select how you want your fields to be listed: by the date they were added, by their types, or by visibility.

Field packages

HPE Consumption Analytics Portal organizes fields into field packages that allow you to put fields into categories that omit irrelevant fields. This helps users easily find the fields they need when creating reports or adding widgets. The All Fields package contains every field. Most of these fields are populated with values by every provider. Any fields not used by every provider (such as Department Name and Cost Center) are grouped in the Other category of the All Fields package. The Other category also contains tags. This field package is maintained by HPE, and cannot be edited.

You can create other field packages that contain a subset of fields chosen by you. Your field packages can also contain groups of fields for a second level of categorization. In your packages you can change field display information, including field labels and (for numeric fields) the number of decimal places included in the displayed value. This level of control within a field package enables you to group and define packages that best suit the specific needs of your users, without altering the actual fields at the source level.

Any permission filters defined for groups and users are applied to the data users see in the Detail dialog box. For more information, see Permissions.

Video overview

The following video helps you understand how fields and field packages are used within HPE Consumption Analytics Portal:

Creating fields

To create a field

  1. On the Data > Fields page, click the Add icon MainAdd_icon.png.
  2. The Create a new custom field dialog box appears.
  3. In the Display Name field, enter the name for this field as it will appear in HPE Consumption Analytics Portal.
  4. (Optional) Enter a Description of the field.
  5. In the Field Type field, specify the type of data stored in the field.
  6. If you are adding a decimal or integer field, enter values for the following fields to determine how you want data displayed in reports:
    • Unit of Measure--For example, %.
    • Currency--If you check this box, the Unit of Measure is set to $ automatically.
  7. If you are adding a decimal field, select the Number of Decimal Places you want displayed in charts and reports.
  8. Select a Default Aggregation Function.
    Your selection determines whether and how data for the field is aggregated in reports. For more information about creating reports, see Reports.
    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.

    Sum

    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.

    Maximum

    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.

    Minimum

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

    Average

    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.

  9. If you want to hide the field, set the Visibility field to Hidden.
    For example, you might have collected several tags, many of which are not needed in charts and reports. By default, hidden fields are not shown in lists of fields elsewhere in HPE Consumption Analytics Portal, though users can opt to show hidden fields in each list. When they do this, hidden fields appear in italics.
  10. Click Save.
Video example

The following video shows you how to create a custom field:

Viewing, editing, and deleting fields

You can view and edit any field. You can delete Custom fields.

To edit or delete a field

  1. In the Fields list, click the name of the field you want to open.
    The Editing Field dialog box appears.

    If the field is used elsewhere in HPE Consumption Analytics Portal (such as in reports, insights, filters, and so on), the dialog lists all of the entities that use the field. For example, the field shown above is used in the VM Details report. You can click an item in the list of locations to open it for editing.
  2. Do one of the following actions:
    If you want to... Do the following...
    Edit the field...

    Update any of the following field properties, and then click Save:

    • Display Name
    • Description
    • Default Aggregation Function of a field
    • Unit of Measure (for decimal and integer fields)
    • Currency (for decimal and integer fields)
    • Number of Decimal Places (for decimal fields)
    • Visibility

    Note that hiding a field only removes it from lists of fields. If a field is already being used in a report, for example, hiding the field does not remove it from the report.

    You cannot change the Field Type.

    Changing the Display Name does not alter the actual name of the field in the database. It merely changes how the field is displayed in HPE Consumption Analytics Portal. If you want to change a Display Name back to its original name, click Reset.

    Delete the field (for Custom fields only)...

    Click Delete, and then click Yes in the confirmation box.

    If the Delete button is not active, it means your Custom field is being used by another entity in HPE Consumption Analytics Portal, such as a report or chart, as listed in the References section. You cannot delete the field as long as those entities are using the field.

    Click an entity name to open a dialog box that enables you to edit that entity. You can then remove the reference to the field you want to delete.

Copying fields

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

To copy a field

  1. On the Fields page, click the gear icon () next to the field you want to copy, and then select Copy.
    A copy of the field opens for editing.
  2. Enter information about the new field, including a new name and description.
  3. Click Save.
    For more information about creating fields, see the Creating fields procedure.

Creating field packages

To create a field package

  1. On the Data > Field Packages page, click the Add icon MainAdd_icon.png.
    The Add Fields to Field Package dialog box appears.
    SelectFields.png
  2. Select the fields you want to add to the package, and then click Select.
    The Create New Field Package page appears.
    CreateFieldPackage.png
  3. To group fields in the package:
    1. In the list of fields in your package, select the fields you want in your group, and then click Add Group.
    2. The Adding a new field package group dialog box appears.
      FieldPackageGroup.png
    3. Enter a Group Name, and then click Save.
      The group is added to your field package.
      CreateFieldPackage2.png
    4. To add fields from outside your field package to the group, click Add Fields, select the fields to add, and then click Select.
  4. To move fields between the main package list and a group, click the move icon FieldMove_icon.png next to a field's checkbox, and drag it to a new location.
  5. When you are done working in your field package, click the Save icon FieldPackageSave_icon.png.
  6. In the dialog box, enter a Field Package Name and a Description, and then click Save.
Video example

The following video shows you how to create a field package:

Last modified

Tags

Classifications

This page has no classifications.
© Copyright 2018 Hewlett Packard Enterprise Development LP