14.1.2.1 Currency Exchange Rates at Time Granularity

This section describes the Time Granularity level in Currency Exchange Rates.

  • Time Granularity may include the following:
    • Beginning of the Day
    • Mid-day
    • End of the Day
    • Any time (running variable), for example, 11 A.M. Rates and 4 P.M. Rates.
  • For each Time Granularity that has to be captured, a Data Version has to be created in the Data Version Dimension entity.
  • Currency Exchange Rates are provided in Staging along with the data version information. For example, you can stamp the Currency Exchange Rates given for three days at 08:00, 08:01, 07:59 as the 'Beginning of the day'.