Report costs by service category and subcategory
Understanding costs across service 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.3, v1.4
- Queries
- 1
- Mode
- Read-only
- Library snapshot (UTC)
- 2026-10-08
Report costs by service category and subcategory v1.3
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, so billed costs cannot be reported at the requested service-subcategory grain.
Original FOCUS SQL
SELECT ServiceProviderName, BillingCurrency, BillingPeriodStart, ServiceCategory, ServiceSubcategory, SUM(BilledCost) AS TotalBilledCost FROM focus_data_table WHERE BillingPeriodStart >= ? and BillingPeriodEnd < ? GROUP BY ServiceProviderName, BillingCurrency, BillingPeriodStart, ServiceCategory, ServiceSubcategory ORDER BY TotalBilledCost DESC
Columns used
Column names from the source use case.