FXRates

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