Interim Consolidations at a Currency Other Than Local and Common
  • 1 Minute to read
  • Dark
    Light
  • PDF

Interim Consolidations at a Currency Other Than Local and Common

  • Dark
    Light
  • PDF

Article summary

In the hierarchy below, to generate a report for Europe in the EUR, you would select Europe rollup member for the Company and then IC1 from the Reporting dimension. Local Currency does not make sense at the parent level as it will be an aggregation of the Local Currency from the children that are in different currencies. Selecting Common Currency at the parent level will make sense and include the appropriate rollups as well as Elimination data.

Total Corp (CC = USD)

North America (Desired currency USD can be accomplished by displaying CC in report)

US (LC = USD)

Canada (LC = CND)

Mexico (LC = MXP)

Europe (Desired currency EUR can be accomplished by setting all children to the same IC)

England (GBP) IC1 = EUR

Spain (EUR) IC1 = EUR

France (EUR) IC1 = EUR

Asia (Desired currency as CNY and USD. USD can be accomplished by displaying CC in a report. Setting all children to the same IC will enable reporting at CNY currency)

China (CNY) IC1 = CNY

Japan (JPY) IC1 = CNY


Was this article helpful?