Global.ForEx

by

Purpose

The Global Foreign Exchange Rate view provides a structured dataset for analysing currency exchange rates relative to the British Pound (GBP) as the base currency. This view supports financial and operational use cases requiring reliable exchange rate data for reporting and analytics.

Use Case

  1. Financial Reporting:
    Provides consistent and up-to-date exchange rate data for financial reports requiring currency conversions.
  2. Operational Analytics:
    Facilitates operational decision-making by ensuring accurate and standardised exchange rates are available.
  3. Regulatory Compliance:
    Ensures historical currency rates are available for audit and compliance purposes.

Source

FACT_CURRENCY_RATES_OL

DataMart Integration

There are no DataMart identifiers

Sample Exec

EXEC get.myView @dataMart = 'Global', @viewName = 'ForEx', @token = '<myToken>', @version = '<202404>'

Response

Output Columns

  • CURRENCY_CODE: Code of the foreign currency.
  • CURRENCY_BASE: Fixed as GBP, representing the base currency.
  • CURRENCY_RATE: The exchange rate from GBP to the foreign currency.
  • BaseValue: The inverse exchange rate (1 / CURRENCY_RATE). Null if the rate is 0.
  • VALID_FROM: The date from which the exchange rate is valid.
  • VALID_UNTIL: The date until which the exchange rate is valid.

Leave a Comment