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

 

 

Consumption Analytics Documentation

Home > Documentation for older versions > Cloud Cruiser 4 for HPE GreenLake Flex Capacity > Working in Cloud Cruiser > Configuring and Administering Azure > Onboarding Azure FC Customers > Configuring Azure Lookup Tables

Configuring Azure Lookup Tables

Lookup tables store data used by Workbooks.  They allow workbooks to be table-driven, which means that data used by the Workbooks can change without requiring you to make changes to the actual Workbooks themselves.

Specific to Azure, Cloud Cruiser includes the 00000_AzureServicesDiscount Lookup Table, which identifies the common discount across all Azure customers for eligible services.  As new Azure services become eligible, this Lookup Table will be updated and the changes propagated through to all Azure customers.  There is also the 00000_AzureFreeServices Lookup Table, which identifies those Azure services that are free for an initial period before being charged normally.  Those are not customer-specific, and the steps to add additional free Azure services can be found at Adding Azure Free Services as it is not part of the customer onboarding process.

The other Azure Lookup Tables are customer-specific and have to be created as part of the onboarding process and maintained whenever the customer-specific discount differs from the discount common to all Azure customers.

Naming Convention

Global Lookup Tables (such as 00000_AzureServicesDiscount), which are used by all Workbooks, should be prefaced by 00000 so they will appear at the top of the list of tables.

Be aware that modifying the global Azure Lookup Table affects every Azure customer.

All customer_specific Azure Lookup Table names should be prefixed by the customer ID you selected for the customer.  For example, 99990_AzureDiscounts.  In these customer-specific Azure Lookup Tables you can specify discounts that apply only to that one customer.

Configuring the Common Customer Lookup Table

Follow the steps at Configuring_the_00000_Customer2AccountID_table to create an entry for the new Azure customer as this is required for all new FC customers.

Adding New Eligible Services for All Azure Customers

This is only necessary if new services become eligible.

Before You Begin

All eligible services' Azure Meter IDs must be known along with their corresponding percentage discounts.    Azure Meter IDs, Meter Names, etc. are described in Microsoft's Azure documentation at Understand your bill for Microsoft Azure.

To Add Eligible Services

  1. Click Data > Setup > Lookup Tables.
  2. Select the 00000_AzureServicesDiscount Lookup Table.
    The Lookup Table is added to the display pane.
  3. Click the plus icon next to the Effective Dates.
    The New Lookup Table dialog box appears.
  4. Enter the date the new service(s) become eligible.
  5. Click OK.
    The Lookup Table with the new Effective Dates is added to the display pane.
  6. Select the second to last row.

It is very important not to select the last row as adding a row after that will cause any Azure MeterIds after it to "match" the default percentage off of zero.  All new rows must come before the last row.

  1. Click Add Row to add the new row.
  2. In the Low ID column, enter an Azure Meter ID (e.g., 964c283a-83a3-4dd4-8baf-59511998fe8b)
  3. In the Target ID column, enter the customer-specific percentage discount (e.g., 5).
  4. Repeat steps 3-6 for each new Azure Meter ID.
  5. Click Save to save the Lookup Table.

Creating the Azure Customer Discount Lookup Table

This is only necessary if the customer has discounts that differ from those that apply to all customers.

Each customer-specific discount Lookup Table includes the eligible Azure services in the HPE FC catalog along with their percentage discounts.

Before You Begin

All eligible services' Azure Meter IDs must be known along with their corresponding customer-specific percentage discounts.    Azure Meter IDs, Meter Names, etc. are described in Microsoft's Azure documentation at Understand your bill for Microsoft Azure.

To Create the Azure Discount Lookup Table

  1. Click Data > Setup > Lookup Tables.
  2. In the list of Lookup Tables, right-click and select Add New Lookup Table.
    The Create New Lookup Table dialog box appears.
  3. In the Name field, enter a name for the table prefixed with the customer ID to which this Lookup Table applies.  For example, to create a Lookup Table to assign discounts for a customer with an ID of 99990, type 99990_AzureDiscounts.
  4. If desired, enter a Description for the Lookup Table.
  5. Click OK.
    The new Lookup Table is added to the display pane.
  6. Click the plus sign to the right of the Effective Dates field to add a starting date for the Lookup Table.  By default, the end date is set as December 31, 2999.
    The Lookup Table options such as Add Row are added to the display pane.
  7. Click Add Row to add the first row.
  8. In the Low ID column, enter an Azure Meter ID (e.g., 964c283a-83a3-4dd4-8baf-59511998fe8b).
  9. In the Target ID column, enter the customer-specific percentage discount (e.g., 5).
  10. Repeat steps 7-9 for each Azure Meter ID.
  11. Once all Azure Meter IDs have been added, click Add Row to add the final row.
  12. In the Target ID column, enter the value of us-0.
    New Lookup Table Complete.png

Do not enter anything in the Low ID column for the last row.  This is meant as a default percentage off of zero for all ineligible Azure services.  Without this row, the processing flow will break.

  1. Click Save to save the Lookup Table.

Updating the Azure Customer Discount Lookup Table

This is only necessary for adding new eligible services for discounts that differ from the common Azure customer discount in the 00000_AzureServicesDiscount Lookup Table.

Before You Begin

All eligible services' Azure Meter IDs must be known along with their corresponding customer-specific percentage discounts.    Azure Meter IDs, Meter Names, etc. are described in Microsoft's Azure documentation at Understand your bill for Microsoft Azure.

To Update the Azure Discount Lookup Table

  1. Click Data > Setup > Lookup Tables.
  2. Click the desired Lookup Table from the list.
    The Lookup Table is added to the display pane.
  3. Select the second to last row.

It is very important not to select the last row as adding a row after that will cause any Azure MeterIds after it to "match" the default percentage off of zero.  All new rows must come before the last row.

  1. Click Add Row to add the new row.
  2. In the Low ID column, enter an Azure Meter ID (e.g., 964c283a-83a3-4dd4-8baf-59511998fe8b)
  3. In the Target ID column, enter the customer-specific percentage discount (e.g., 5).
  4. Repeat steps 3-6 for each new Azure Meter ID.
  5. Click Save to save the Lookup Table.

 

Last modified

Tags

This page has no custom tags.

Classifications

This page has no classifications.

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