![]() |
Consumption Analytics Documentation |
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.
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
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
If you want to create a lookup based on an existing lookup, you can make a copy.
To copy a lookup
(c) Copyright 2017-2020 Hewlett Packard Enterprise Development LP