Currency consolidation

A currency consolidation starts with an implicit local consolidation, unless the request includes the option to skip the local consolidation process. A currency consolidation also posts journals and performs currency translations.

In addition to the common actions of each phase, a currency consolidation includes these unique actions:

  • RPT reads input data and evaluates downfoot formulas and any formulas controlled by if rpt, if not xlt, and if not cons logic. In addition, RPT posts Standard, Standard PL-BS, Standard Reversal, Standard PL-BS Reversal, Acquisition, and, if optionally created, Intercompany Eliminations journals to local currency for all leaf members. Then leaf data is rolled up in the Period dimension and all hierarchical custom dimensions.
  • XLT translates data, posts journals to the specified currency and rate set, and evaluates downfoot formulas as well as any formulas controlled by the if not rpt, if xlt, if not cons logic. Leaf data is then rolled up in the Period dimension and all hierarchical dimensions, including the Unit dimension. The if xlt formulas produce results only in translated currencies.
  • CONS evaluates downfoot formulas for both leaf and parent Period dimension member and all hierarchical dimension members, including the Unit dimension, as well as any formulas controlled by the if not rpt, if not xlt, and if cons logic.

A request for a currency consolidation omits the *local parameter.