Allocate multi-currency charges per application
This query uses the ProviderName column. ProviderName is deprecated in v1.3 and will be removed in v1.4.
FOCUS Versions
v1.0
v1.1
v1.2
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"],
ProviderName,
BillingAccountId,
BillingAccountName,
BillingCurrency,
SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE
BillingPeriodStart >= ? AND BillingPeriodEnd < ?
GROUP BY
Tags["ApplicationId"],
ProviderName,
BillingAccountId,
BillingAccountName,
BillingCurrencyFOCUS Datasets
FOCUS Columns
Related Capabilities
Related Personas
Related KPIs
Usage or Spend Apportionment Validation
Method of apportioning shared costs based on usage or spend proportional amount.
Percentage of Unallocated Shared CSP Cloud Cost
Measure expenses that cannot be directly attributed to a specific project, team, or department within an organization.
Percentage of Costs Associated with Untagged CSP Cloud Resources
Calculate percentage of untagged cloud resources using an established organizational tagging policy.
Percentage of Costs Associated with Unallocated CSP Cloud Resources
Track expenses incurred for resources or services that are not directly attributed to specific projects, departments, or applications.
General Ledger Recharge Rate
Measure total cloud spend in the cloud management tool vs. amount charged in General Ledger (Finance application).
General Ledger Recharge Rate per Cost Center
See cloud spend in the cloud management tool per Cost Center vs. amount charged in General Ledger.
Fixed Percentage Apportionment Validation
Method of apportioning shared costs based on Fixed Percentage.