FOCUSExplorer
Use cases
Read-only sample

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

Allocate multi-currency charges per application

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

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

Allocate Multi-Currency Charges per Application v1.3

Adapted to v1.0
Source
FOCUS 1.0 sample
Result rows
500
Status
Adapted to v1.0
Execution
PrecomputedRead-only
Result snapshot (UTC)
2026-10-11

Billed cost per application tag, service provider, billing account and billing currency for chargeback. The sample has no ApplicationId tag; its application tag key is 'application' (a param, so any key can be used). Every populated billing currency in the sample is USD, so the multi-currency split shows a single currency (plus null for 4 Oracle rows).

Column adaptations (2)
  • ServiceProviderName → case when publisher_name is not null and publisher_name is distinct from invoice_issuer_name then publisher_name else provider_name end: v1.3 replaced ProviderName with ServiceProviderName (the seller in marketplace scenarios). v1.0 ProviderName supplies it for direct-provider charges; PublisherName supplies it for the observed AWS Marketplace sellers (Datadog, Red Hat) where it differs from InvoiceIssuerName. Same expression as the other v1.3 catalog entries.
  • Tags["ApplicationId"] → tags->>$3 (default 'application'): Tag keys are user-defined; the sample's application tag is 'application', so the key is a parameter.

Billed cost by application and currency

Chart controls and notes

Showing the first 20 categories. Open full screen to explore all 496 categories.

Query results
Application idService provider nameBilling account idBilling account nameBilling currencyTotal billed cost
BrightPathMatrixAWS1234567890123SunBirdUSD$1,374.63
–Microsoft/providers/Microsoft.Billing/billingAccounts/8611537SunBirdUSD$567.21
–Datadog Inc.1234567890123SunBirdUSD$40.98
ZoomMapMaxAWS1234567890123SunBirdUSD$24.38
PureGeniusPilotAWS1234567890123SunBirdUSD$20.71
GlobalConsoleCloudAWS1234567890123SunBirdUSD$18.64
GenWebFlexAWS1234567890123SunBirdUSD$14.13
BrightInsightPortAWS1234567890123SunBirdUSD$14.11
GlobalClarityNextAWS1234567890123SunBirdUSD$9.43
MetaLabPowerOracle20209880–USD$7.87
ClearSolutionLogicAWS1234567890123SunBirdUSD$6.95
GreenGuideIQAWS1234567890123SunBirdUSD$6.21
PrimeNavigatorWaveAWS1234567890123SunBirdUSD$5.81
ProAccessPilotAWS1234567890123SunBirdUSD$4.79
OmniBoltFlexAWS1234567890123SunBirdUSD$4.77
ClearWebCentralAWS1234567890123SunBirdUSD$4.71
PowerRadarCoreAWS1234567890123SunBirdUSD$4.71
LeadChainLiteAWS1234567890123SunBirdUSD$4.66
ProEngineMatrixAWS1234567890123SunBirdUSD$3.70
ZoomBridgeInsightAWS1234567890123SunBirdUSD$3.44
ProMatrixCentralAWS1234567890123SunBirdUSD$3.23
VisionToolkitConnectOracle20209880–USD$3.20
EvolveManagerPortOracle20209880–USD$3.20
BlueScopeInsightAWS1234567890123SunBirdUSD$3.20
DynamicScopeEdgeOracle20209880–USD$3.20
SafeDNACentralAWS1234567890123SunBirdUSD$3.13
BlueLensIQOracle20209880–USD$3.07
HyperOptimizerStudioAWS1234567890123SunBirdUSD$2.91
ActiveManagerLinkAWS1234567890123SunBirdUSD$2.85
MetaNavigatorEngineAWS1234567890123SunBirdUSD$2.84
SmartAccessSmartAWS1234567890123SunBirdUSD$2.81
OptiBoxProAWS1234567890123SunBirdUSD$2.80
OptiZoomInfinityAWS1234567890123SunBirdUSD$2.78
ProOptimizerForceAWS1234567890123SunBirdUSD$2.73
DynamicFocusHubAWS1234567890123SunBirdUSD$2.72
MaxPortalFusionAWS1234567890123SunBirdUSD$2.70
TrueStreamEssentialsAWS1234567890123SunBirdUSD$2.57
BlueManagerInfinityAWS1234567890123SunBirdUSD$2.54
AllProjectorSmartAWS1234567890123SunBirdUSD$2.48
ZoomLinkCloudAWS1234567890123SunBirdUSD$2.42
FlexGeniusFlowAWS1234567890123SunBirdUSD$2.42
EvolveVaultLabAWS1234567890123SunBirdUSD$2.30
PrimeMirrorFusionAWS1234567890123SunBirdUSD$2.22
EvolveLabEssentialsAWS1234567890123SunBirdUSD$2.18
CorePortalMaxAWS1234567890123SunBirdUSD$2.16
GenBoltEssentialsAWS1234567890123SunBirdUSD$2.06
PrimeRingHubAWS1234567890123SunBirdUSD$1.95
SecureBoltFusionAWS1234567890123SunBirdUSD$1.91
MaxCodeEssentialsAWS1234567890123SunBirdUSD$1.84
BluePrimeDriveAWS1234567890123SunBirdUSD$1.81
AlphaZoomPulseAWS1234567890123SunBirdUSD$1.79
BrightModelPowerAWS1234567890123SunBirdUSD$1.78
PowerPilotEssentialsAWS1234567890123SunBirdUSD$1.74
GenBoxLiteRed Hat Inc.1234567890123SunBirdUSD$1.71
MetaEngineEssentialsOracle20209880–USD$1.60
OptiDriveCentralAWS1234567890123SunBirdUSD$1.58
PrimeCompassMatrixAWS1234567890123SunBirdUSD$1.57
GenFlowPrimeAWS1234567890123SunBirdUSD$1.55
EasyLogicConnectAWS1234567890123SunBirdUSD$1.55
PrimeLabEngineAWS1234567890123SunBirdUSD$1.54
ClearNetworkBoostAWS1234567890123SunBirdUSD$1.54
BrightMapPulseAWS1234567890123SunBirdUSD$1.54
MetaSuiteLiteAWS1234567890123SunBirdUSD$1.54
NextAccessFusionAWS1234567890123SunBirdUSD$1.54
NextFusionMaxAWS1234567890123SunBirdUSD$1.54
QuickMapPulseAWS1234567890123SunBirdUSD$1.54
SecureProjectorPowerOracle20209880–USD$1.54
TrueDriveSphereOracle20209880–USD$1.54
QuickNavigatorDriveAWS1234567890123SunBirdUSD$1.47
VitalMindPortAWS1234567890123SunBirdUSD$1.47
ProManagerMaxAWS1234567890123SunBirdUSD$1.42
TotalMatrixBoostAWS1234567890123SunBirdUSD$1.37
FastCloudPathAWS1234567890123SunBirdUSD$1.34
EasyZoomFlowAWS1234567890123SunBirdUSD$1.33
SecurePanelBoostAWS1234567890123SunBirdUSD$1.33
GenManagerGoAWS1234567890123SunBirdUSD$1.33
UltraCenterCloudAWS1234567890123SunBirdUSD$1.32
TotalEngineMatrixAWS1234567890123SunBirdUSD$1.31
MetaAccessDriveAWS1234567890123SunBirdUSD$1.27
TotalMapBoostAWS1234567890123SunBirdUSD$1.24
GenBoxLiteAWS1234567890123SunBirdUSD$1.17
BrightPortalVisionAWS1234567890123SunBirdUSD$1.15
AlphaCloudCloudAWS1234567890123SunBirdUSD$1.15
InsightNavigatorFusionAWS1234567890123SunBirdUSD$1.15
PowerBuilderCentralAWS1234567890123SunBirdUSD$1.15
BrightLensMatrixAWS1234567890123SunBirdUSD$1.13
ClearCodePulseAWS1234567890123SunBirdUSD$1.11
GenFactorZoneAWS1234567890123SunBirdUSD$1.11
MetaCompassMatrixAWS1234567890123SunBirdUSD$1.10
BrightDriveVisionAWS1234567890123SunBirdUSD$1.09
ActiveRingEngineAWS1234567890123SunBirdUSD$1.09
CoreBuilderNowAWS1234567890123SunBirdUSD$1.08
PrimeManagerDriveAWS1234567890123SunBirdUSD$1.07
PowerScopePilotAWS1234567890123SunBirdUSD$1.04
MaxMatrixFlexRed Hat Inc.1234567890123SunBirdUSD$1.03
UnifiedStoreEngineAWS1234567890123SunBirdUSD$1.02
TechMatrixNextAWS1234567890123SunBirdUSD$1.02
TruePlanNetAWS1234567890123SunBirdUSD$1.02
SafeBridgeVaultAWS1234567890123SunBirdUSD$1.00
FlexBrainStudioAWS1234567890123SunBirdUSD$1.00

Showing 100 of 500 rows. Scroll inside the table to see more.

Precomputed result

Inspect Postgres SQL and original FOCUS SQL

Postgres SQL, as run

select tags->>$3::text as application_id,
       case when publisher_name is not null and publisher_name is distinct from invoice_issuer_name then publisher_name else provider_name end as service_provider_name,
       billing_account_id,
       billing_account_name,
       billing_currency,
       sum(billed_cost) as total_billed_cost
from focus.cost_and_usage
where billing_period_start >= $1::timestamptz
  and billing_period_end < $2::timestamptz
group by 1, 2, 3, 4, 5
order by total_billed_cost desc nulls last, application_id nulls last, service_provider_name, billing_account_id
limit 500

Parameters: $1 = billing_period_start, $2 = billing_period_end, $3 = application_tag_key

Original FOCUS SQL

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

Columns used

Column names from the source use case.

  • Service Provider Name
  • Billing Account ID
  • Billing Account Name
  • Billing Currency
  • Billed Cost
  • Tags
  • Billing Period Start
  • Billing Period End
Read the source on focus.finops.org ↗