Working with Currency Conversion Calculation Scripts

If multiple currencies are enabled for the Oracle Hyperion Planning application when you create a currency conversion, a currency conversion calculation script is created, based on selected scenarios, versions, and currencies. A second calculation script is generated by Planning, which copies appropriate exchange rates to the account, based on account rate types. For currency conversion, the Account type always takes precedence. Data type evaluation order is not considered. The copy calculation script is named HspCrtB.csc for bottom-up versions and HspCrtT.csc for target versions. Running the copy calculation script enables the currency conversion calculation script to run in BLOCK mode, which is more efficient than CELL mode.

The selected scenarios, versions, and currencies must be able to store data in the database outline. Dynamic Calc, Dynamic Calc and Store, and Label Only are virtual members that do not store data. There is no benefit to running the copy of the currency conversion calculation script if the target version has virtual members because Planning discards the results of the calculation for these members.

To convert currencies correctly, the first time a currency conversion is launched, administrators must run the copy currency rates calculation script and the currency conversion calculation script. After launching the HSPCrtB.csc or HspCrtT.csc copy calculation script, you must launch them again if you change the database outline (for example, by adding or changing exchange rates, account rate types, versions, scenarios, accounts, or user-defined dimension members).

To create the copy currency calculation script for calculation scripts, you must regenerate currency conversion calculation scripts.