Report effective cost of compute

FOCUS Versions

v1.3 v1.4

Context

Engineers and Engineering Managers want to reduce their billed cost for Compute from a specific service provider. In order to do that, they need to know the current rate of commitment-based discounts (without contracted discounts) per type of commitment. This helps to strategize further purchases.

FOCUS SQL Query

SELECT
  CommitmentDiscountType,
  ServiceProviderName,
  ServiceName,
  SubAccountId,
  SubAccountName,
  BillingPeriodStart,
  SUM(EffectiveCost) AS TotalEffectiveCost
FROM focus_data_table
WHERE BillingPeriodStart  >= ? AND BillingPeriodEnd <= ?
  AND ServiceCategory = 'Compute'
GROUP BY
  CommitmentDiscountType,
  ServiceName,
  ServiceProviderName,
  SubAccountId,
  SubAccountName,
  BillingPeriodStart

FOCUS Datasets

Cost and Usage Contract Commitment Billing Period Invoice Detail

FOCUS Columns

Commitment Discount Type Service Name Service Provider Name Sub Account ID Billing Period Start Effective Cost Service Category Billing Period End

Engineering

Previous Quantify usage of a component resource Next Calculate Commitment Discount Coverage Rate with Eligibility-Adjusted Denominator