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