- edited on
Answer: Configuration touchpoints:EntityTime ProfilesScenariosFX RatesCubesData Integration – moving data between cubes
Due to FX Rate tables being stored by cube, you’ll need separate scenario dimensions for each respective entity dimension.
Create separate entity dimensions for each local reporting year-end.
Duplicate scenarios to accommodate FX rates by currency and fiscal year.
Summary Accts – level used for planning
Detail Accounts – level used for group financial reporting
LL (Local/Legal) Accounts – additional detail and alternate hierarchies for country specific COA
Sample app available as attachment
Source: Office Hours 2020-02-13 Partner Enablement