Allocate multi-currency charges per application

FOCUS Versions

v1.3 v1.4

Context

Finance needs to allocate costs and perform chargeback for charges for all applications that come from different geographic locations and are in different currencies.

FOCUS SQL Query

SELECT 
  Tags["ApplicationId"],
  ServiceProviderName,
  BillingAccountId,
  BillingAccountName,
  BillingCurrency,
  SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE
  BillingPeriodStart >= ? AND BillingPeriodEnd < ?
GROUP BY
  Tags["ApplicationId"],
  ServiceProviderName,
  BillingAccountId,
  BillingAccountName,
  BillingCurrency

FOCUS Datasets

Contract Commitment Cost and Usage Invoice Detail Billing Period

FOCUS Columns

Service Provider Name Billing Account ID Billing Account Name Billing Currency Billed Cost Tags Billing Period Start Billing Period End

Next Analyze cost by participating entities