Consumption Analytics Documentation

Home > HPE Consumption Analytics Portal Documentation > Configuring the HPE Consumption Analytics Portal > Lookups

Lookups

Lookups are tables of data that you add to HPE Consumption Analytics Portal. They generally represent business data that is not part of your cloud usage and cost data. For example, you might add a lookup that maps organizational levels in your company, such as departments to business units.

You can then use SmartTags rules to translate values in your source data based on values in your lookups. For example, your collected usage and cost data might include a Department field, but not a Business Unit field. If you have a lookup that maps your departments to business units, you can create a SmartTags rule to set a Business Unit field to a value based on its Department in the lookup.

When HPE Consumption Analytics Portal scans a lookup column for a match, if it finds more than one match it randomly uses one of the matching rows. For this reason, ensure that the column you search with a SmartTags rule has unique values.

For more information about SmartTags rules and the Set field from lookup action, see SmartTags.

Creating lookups

If you do not have an existing CSV file to upload, you can create a new lookup in HPE Consumption Analytics Portal.

To create a lookup

  1. Click Data in the left navigation.
    The Data page displays:
    CAP_data_collections_main.png
  2. Click the Lookups tab at the top left of the Data page.
  3. Click the + icon.
    A new table displays, with Source and Destination columns:
    CAP_data_collections_lookup_add.png
    • To add a new column, click Add Column.
    • To change the name of a column, click the column header and then enter a new name.
  4. Enter data in each cell by clicking into the cell and then entering a value.
    • If you need more rows, click Add Row to add a row to the bottom of the table.
    • If you want to delete a row, click the trash can icon to the right of the row 
  5. Click the edit icon next to the title and enter a title,
  6. Click Save.
    CAP_data_collections_lookup_complete.png
    Your new lookup is added to the list of available lookups, and can now be used by SmartTags rules. For more information about using the Set field from lookup action, see SmartTags rules.
Uploading lookups

If you have an existing CSV file that you would like to use as a lookup in HPE Consumption Analytics Portal, you can upload that file. For example, you might have a database from which you can export a CSV file.  

Your CSV file can have no more than 20 columns, and can be no larger than 10 MB.

To upload a CSV file as a lookup

  1. On the Data page, click the ellipsis.
  2. In the menu, click the Import CSV option.
  3. Enter a Lookup Name and a Lookup Description.
  4. Click Upload File, and then browse to locate your CSV file.
  5. If the first row of your file should be used as column headers, check the First row contains column headers box.
  6. Click Save.
    Your new lookup is added to the list of available lookups, and can now be used by SmartTags rules.

Copying lookups

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

To copy a lookup

  1. On the Data page, click the ellipsis.
  2. In the menu, click the Copy option.
    A copy of the lookup opens in the lookup editor.
  3. Modify the lookup as needed.
  4. Click the Save icon in the top right corner
    The Save Lookup popup displays.
  5. Give the lookup a new name and description.
  6. Click Save.
Last modified

Tags

Classifications

This page has no classifications.

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