FOCUS Specification

2.11.1 Description

FOCUS supports the analysis of cost and usage data for marketplace purchases and their associated costs. It also supports the reporting of EffectiveCost for usage from the provider.

2.11.2 Directly Dependent Columns

InvoiceIssuer Provider

2.11.3 Supporting Columns

Billed Cost Effective Cost

2.11.4 Example SQL Query on a CSP Marketplace FOCUS Dataset

Example SQL Query on a CSP Marketplace FOCUS Dataset

SELECT
  Provider,
  InvoiceIssuer,
  BillingPeriodStart,
  BillingPeriodEnd,
  SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE Provider = '<Example SaaS Provider>'
  AND InvoiceIssuer = '<Example CSP Marketplace>'
GROUP BY
  Provider,
  InvoiceIssuer,
  BillingPeriodStart,
  BillingPeriodEnd

2.11.5 Example SQL Query on a Provider FOCUS Dataset

Example SQL Query on a Provider FOCUS Dataset

SELECT
  ChargePeriodStart,
  ChargePeriodEnd,
  ResourceId,
  SUM(EffectiveCost) AS TotalEffectiveCost
FROM focus_data_table
WHERE InvoiceIssuer = '<Example CSP Marketplace>'
GROUP BY
  ChargePeriodStart,
  ChargePeriodEnd,
  ResourceId

2.11 Marketplace Purchases