Analyze cost by participating entities

FOCUS Versions

v1.3 v1.4

Context

Break down costs by service provider, invoice issuer, and host provider to understand the complete value chain and identify reseller margins or marketplace fees.

FOCUS SQL Query

SELECT
  BillingPeriodStart,
  BillingPeriodEnd,
  ServiceProviderName,
  InvoiceIssuerName,
  HostProviderName,
  ServiceName,
  BillingCurrency,
  SUM(BilledCost) AS TotalBilledCost
 FROM focus_data_table
 WHERE BillingPeriodStart >= ? AND BillingPeriodEnd < ?
 GROUP BY
  BillingPeriodStart,
  BillingPeriodEnd,
  ServiceProviderName,
  InvoiceIssuerName,
  HostProviderName,
  ServiceName,
  BillingCurrency
 ORDER BY TotalBilledCost DESC