Report service costs by providers subaccount

FOCUS Versions

v1.3 v1.4

Context

Organizations wants to negotiate private pricing for a particular workload, a subaccount that carries specialized workloads, or their entire footprint. The cost metric used must amortize up-front and recurring fees to get an accurate view of the effective cost.

FOCUS SQL Query

v1-3

SELECT 
  ServiceProviderName,
  ServiceName,
  SubAccountId,
  ChargePeriodStart,
  SUM(EffectiveCost) AS TotalEffectiveCost
FROM focus_data_table
WHERE BillingPeriodStart >= ? AND BillingPeriodEnd < ?
  AND SubAccountId = ?
  AND ServiceProviderName = ?
GROUP BY 
  ServiceProviderName,
  ServiceName,
  SubAccountId,
  ChargePeriodStart
ORDER BY 
  SUM(EffectiveCost),
  BillingPeriodStart DESC

v1-4

SELECT 
  ServiceProviderName,
  ServiceName,
  SubAccountId,
  ChargePeriodStart,
  SUM(EffectiveCost) AS TotalEffectiveCost
FROM focus_data_table
WHERE BillingPeriodStart >= ? AND BillingPeriodEnd < ?
  AND SubAccountId = ?
  AND ServiceProviderName = ?
GROUP BY 
  ServiceProviderName,
  ServiceName,
  SubAccountId,
  ChargePeriodStart
ORDER BY 
  SUM(EffectiveCost),
  BillingPeriodStart DESC

FOCUS Datasets

Contract Commitment Cost and Usage Billing Period Invoice Detail

FOCUS Columns

Service Provider Name Service Name Sub Account ID Charge Period Start Effective Cost Billing Period Start Billing Period End Effective Cost

Finance

Previous Report on initial contract commitments Next Report spending across billing periods for a service provider by service category