The FXRates store contains all the FX Rates. It is an isolated store and not part of any cube facts.The store is index by BaseCcy, CounterCcy, and AsOfDate. FX Rates are looked up via the IFXRates API by these three fields.
Store Field
Key
CanBeNull
Type
Description
BaseCcy
Y
String
The left side of the currency pair
CounterCcy
Y
String
The right side of the currency pair
FxRate
Double
Forex rate between the two currencies
AsOfDate
Y
LOCALDATE[yyyy-mm-dd]
Timestamp (at close of business) for the data
Was this page helpful?
⌘I
Assistant
Responses are generated using AI and may contain mistakes.
