Skip to main content
Documentation - HPE Consumption Analytics

Creating a lookup table for showback reporting

In a typical showback scenario, as a customer using HPE GreenLake resources, you want a breakdown of resource cost by unique identifier - for example, the cost of your devices or components by department or division (business unit). 

If your data collection doesn't tag resources to your business units, and you can't add a tag to map resources to your business units, you can use the Lookup tables and SmartTags  features in HPE Consumption Analytics to enable showback. 

Lookups are tables of data that you add to HPE Consumption Analytics Portal.  They generally represent business data that is not already part of your resource usage and cost data.  For showback, you can create a lookup table to tag business units, such as departments or divisions, to your devices or components.

You can then use SmartTags rules to translate values in your source data based on values in your lookup table. For showback, if you have a lookup that includes your business units, you can create a SmartTags rule to add a business unit field to your data collection and set it to a value based on a value found in the lookup.

This page will walk you through uploading your file to create a lookup table for showback. 

This article covers this step in the showback process:

CAP_showback_step6.png

See Working with showback for HPE GreenLake services for the full process chart and context.

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 lookup table column you search with a SmartTags rule has unique values.

Creating a lookup table

The following steps will walk you through creating a lookup table using a CSV file of your resources.

Uploading a lookup

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

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 Lookups page, click the upload icon at top right. 
    The Upload Lookup popup opens:
    CAP_data_collections_lookup_upload_popup.png

  2. Enter a Lookup Name and a Lookup Description.
  3. If the first row of your file should be used as column headers, check the First row contains column headers box.
  4. Click Upload File, and then browse to locate your CSV file:
    Upload CSV to Lookup.png

  5. Click Save.
  6. Your new lookup is added to the list of available lookups, and can now be used by SmartTags rules.

Next step

Once you've completed this step, continue to the next article in the process path below.