Modifying dimensions and members in the main database outline enables Essbase to automatically generate the currency database outline, as follows:
To modify the main database outline in preparation for currency conversion:
Tag a dimension as time, if a time dimension does not exist.
Tag a dimension as accounts, if an accounts dimension does not exist.
Assign a currency category to the accounts dimension and to members within this dimension to handle different categories of exchange rates. Tag all members that should not be converted as No Conversion. The No Conversion tag is not inherited.
Assign currency names to individual countries.
Optional: Create a currency partition to tell Essbase which part of the database holds local data and which holds base data.
Apply the Label Only tag to dimensions and members that do not store data. See Setting Member Consolidation Properties.
If the database already contains data values, Essbase restructures the database to reflect changes to the outline.