Currency conversion applications consist of two databases: a main database and a currency database. Before currency conversion can be performed, you must link the main database to the currency database. If you have Database Manager permissions, you can select the currency database to link to, the conversion calculation method to use, and the default currency type member.
To link a database to a currency database and to specify related settings:
From Enterprise View or a custom view, select a database.
Right-click and select Edit, and then Properties.
In the Database Properties window, select the Currency tab.
For the Currency database option, select a currency database to link.
In Default currency type member, enter the Currency Type member to use as a default in currency conversions. You can specify any valid member of the CurType dimension in the currency database.
Click Apply to apply the settings and create the link to the currency database.
alter database (MaxL) in the Oracle Essbase Technical Reference
setdbstate (ESSCMD) in the Oracle Essbase Technical Reference
setdbstateitem (ESSCMD) in the Oracle Essbase Technical Reference