- 1 Minute to read
- Print
- DarkLight
- PDF
Interim Consolidations at a Currency Other Than Local and Common
- 1 Minute to read
- Print
- DarkLight
- PDF
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