Inspect the result, its parameters and the SQL behind it.
The v1.0 sample lacks PricingCurrency and PricingCurrencyEffectiveCost, so BillingCurrency and EffectiveCost cannot reproduce pricing-denominated costs or exchange-rate effects.
SELECT
ServiceProviderName,
HostProviderName,
ServiceName,
PricingCurrency,
SUM(PricingCurrencyEffectiveCost) AS TotalPricingCurrencyEffectiveCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd < ?
GROUP BY
ServiceProviderName,
HostProviderName,
ServiceName,
PricingCurrency