Report spending across billing periods for a service provider by service category

FOCUS Versions

v1.3 v1.4

Context

Understanding costs across service providers, billing periods, billing accounts, and service categories (Analytics, Compute, Database, Storage, etc.) provides valuable insight into total costs and can be used by Procurement to focus negotiations for specific service providers with details on the billing accounts that are driving costs to focus negotiations toward highest costing items.

FOCUS SQL Query

SELECT
ServiceProviderName,
BillingAccountName,
BillingAccountId,
BillingCurrency,
BillingPeriodStart,
ServiceCategory,
ServiceName,
SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd < ?
AND ServiceProviderName = ?
GROUP BY
ServiceProviderName,
BillingAccountName,
BillingAccountId,
BillingCurrency,
BillingPeriodStart,
ServiceCategory,
ServiceName
ORDER BY TotalBilledCost DESC

FOCUS Datasets

Contract Commitment Cost and Usage Invoice Detail Billing Period

FOCUS Columns

Service Provider Name Billing Account Name Billing Account ID Billing Currency Billing Period Start Service Category Service Name Billed Cost Charge Period Start Charge Period End

Procurement

Previous Report service costs by providers subaccount Next Analyze credit memos