FOCUSExplorer
Use cases
Read-only sample

FOCUS 1.0 billing data. Reference snapshots are dated on each page.

Analyze effective cost by pricing currency

Break down the effective cost by each pricing currency to surface regional price differences and exchange-rate impacts.

← Allocation
Source
FOCUS MCP snapshot
FOCUS editions
v1.2
Queries
1
Mode
Read-only
Library snapshot (UTC)
2026-10-08

This query uses the ProviderName column. ProviderName is deprecated in v1.3 and will be removed in v1.4.

Personas
FinOps Practitioner, Finance
Capabilities
Allocation, Budgeting, Forecasting, Planning & Estimating, Reporting & Analytics, Rate Optimization

Analyze Effective Cost by Pricing Currency

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

PricingCurrency and PricingCurrencyEffectiveCost are absent from the v1.0 sample, so effective cost cannot be expressed in the pricing currency.

Review the original SQL below and the required columns before using a newer FOCUS dataset.

Original FOCUS SQL
SELECT
    ProviderName,
    PublisherName,
    ServiceName,
    PricingCurrency,
    SUM(PricingCurrencyEffectiveCost) AS TotalPricingCurrencyEffectiveCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd  < ?
GROUP BY
    ProviderName,
    PublisherName,
    ServiceName,
    PricingCurrency

Columns used

Column names from the source use case.

  • Provider Name
  • Publisher Name
  • Service Name
  • Pricing Currency
  • Pricing Currency Effective Cost
  • Charge Period Start
  • Charge Period End
Read the source on focus.finops.org ↗