Report costs by service category and subcategory
Understanding costs across providers, billing periods, and service categories (Analytics, Compute, Database, Storage, etc.) and service subcategories (Virtual Machines, Relational Databases, Content Delivery, etc) provides valuable insight into total costs.
- Source
- FOCUS MCP snapshot
- FOCUS editions
- v1.1, v1.2
- Queries
- 1
- Mode
- Read-only
- Library snapshot (UTC)
- 2026-10-08
This query uses the Provider column. Provider is deprecated in v1.3 and will be removed in v1.4.
Report costs by service category and subcategory
Not in v1.0 sample- Source
- FOCUS use-case SQL
- Status
- Not in v1.0 sample
- Results
- Not run
- Mode
- Read-only
- Library snapshot (UTC)
- 2026-10-08
ServiceSubcategory is absent from the v1.0 sample (it was added in FOCUS v1.1), so costs cannot be reported at the service-subcategory grain.
Original FOCUS SQL
SELECT ProviderName, BillingCurrency, BillingPeriodStart, ServiceCategory, ServiceSubcategory, SUM(BilledCost) AS TotalBilledCost FROM focus_data_table WHERE BillingPeriodStart >= ? and BillingPeriodEnd < ? GROUP BY ProviderName, BillingCurrency, BillingPeriodStart, ServiceCategory, ServiceSubcategory ORDER BY TotalBilledCost DESC
Columns used
Column names from the source use case.