Configuring the fact tables

CURRENCYRATE and LEDGER are fact tables. They contain the values that are stored in a cube.

• LEDGER: To load values of a fact table, at least one field must be of the type IS_MEASURE or IS_FIXEDCURRENCYMEASURE.
• CURRENCYRATE: These fields must be specified: Field of the source currency (Conversion code from) and the field of the target currency (Conversion code to) must be of the type IS_CURRENCYCODE. The period field must be of the type IS_PERIOD. If a conversion operator exists, it must be of the type IS_CONVERSIONOPERATOR. The fields that contain the exchange rates must be of the type IS_CURRENCYRATE. There must be at least one field of the type IS_CURRENCYRATE.