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 for Partner Center > Onboarding Azure for Partner Center FC Customers > Configuring Azure for Partner Center Lookup Tables

Configuring Azure for Partner Center 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 following Lookup Tables:

  • 00000_AzureServicesDiscount, 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.
  • 00000_AzureSupportCosts, which identifies the four bands and their corresponding thresholds and percentage of charges to determine the monthly support costs.  This serves as the template for the customer-specific Lookup Tables.
  • 00000_AzureTierDiscounts, which identifies the four bands and their corresponding thresholds and percentage of charges to determine the monthly discounts.  This serves as the template for the customer-specific Lookup Tables.
  • 00000_AzureFreeServices, 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.

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_AzureSupportCosts or 99990_AzureTierDiscounts In these customer-specific Azure Lookup Tables you can specify values 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 percentage discount.

For Partner Center customers, this will be 0 as the discounts are applied monthly based on charges.

  1. Repeat steps 3-6 for each new Azure Meter ID.
  2. Click Save to save the Lookup Table.

Creating the Azure Customer Support Costs Lookup Table

Each customer-specific support costs Lookup Table includes the four bands along with their pipe-delimited thresholds and percentages.

Before You Begin

All four bands' thresholds and percentages must be known.

To Create the Azure Customer Support Costs 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 support costs for a customer with an ID of 99990, type 99990_AzureSupportCosts.
  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 Band1.
  9. In the Target ID column, enter the low-end of the band's threshold followed by a pipe followed by the band's percentage of total costs (e.g., 1|10).
  10. Repeat steps 7-9 for each band incrementing the band's index (e.g., Band2, Band3, Band4).
  11. Click Save to save the Lookup Table.

Creating the Azure Customer Discounts Lookup Table

Each customer-specific discounts Lookup Table includes the four bands along with their pipe-delimited thresholds and percentages.

Before You Begin

All four bands' thresholds and percentages must be known.

To Create the Azure Customer Discounts 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 support costs for a customer with an ID of 99990, type 99990_AzureTierDiscounts.
  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 Band1.
  9. In the Target ID column, enter the low-end of the band's threshold followed by a pipe followed by the band's percentage of total costs (e.g., 1|4).
  10. Repeat steps 7-9 for each band incrementing the band's index (e.g., Band2, Band3, Band4).
  11. 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