Determine contracted savings by virtual currency
Compare the virtual currency discounted rate to the virtual currency list price to determine the difference, as contracts can lower the virtual-currency price of certain operations.
- Source
- FOCUS MCP snapshot
- FOCUS editions
- v1.2, v1.3, v1.4
- Queries
- 1
- Mode
- Read-only
- Library snapshot (UTC)
- 2026-10-08
Determine Contracted Savings by Virtual 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, PricingCurrencyListUnitPrice, PricingCurrencyContractedUnitPrice and ServiceSubcategory are absent from the v1.0 sample, so savings in a virtual pricing currency cannot be computed.
Original FOCUS SQL
SELECT
ServiceName,
ServiceSubcategory,
ChargeDescription,
BillingCurrency,
PricingCurrency,
SUM(PricingCurrencyListUnitPrice-PricingCurrencyContractedUnitPrice) AS ContractedSavingsInPricingCurrency,
SUM(ListUnitPrice - ContractedUnitPrice) AS ContractedSavingsInBillingCurrency
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd < ?
AND PricingCurrencyListUnitPrice > PricingCurrencyContractedUnitPrice
GROUP BY
ServiceName,
ServiceSubcategory,
ChargeDescription,
BillingCurrency,
PricingCurrencyColumns used
Column names from the source use case.