If you are unfamiliar with Planning for Oracle Planning and Budgeting Cloud Service, see the Oracle Hyperion Planning User's Guide, available on the Oracle Cloud help center.
The Calculate Data Form business rule is created for each form to calculate subtotals. The Calculate Currencies business rule is created for forms that include multiple currencies in a row, column, or page to enable the conversion of values among available currencies.
The order in which business rules are launched is important and may affect the data. If you plan to launch both Calculate Data Form and the Calculate Currencies business rules, always run the conversions before subtotaling the form.
To launch the Calculate Data Form and Calculate Currencies business rules in Excel:
Any data that is not saved on the spreadsheet is lost when you launch the business rule.
From the Planning ribbon, select Calculate, and then Rules on Form.
The business rules associated with the form are displayed in the Business Rules dialog box.
Complete one or both of the following actions:
To convert currencies, select Calculate Currencies.
To calculate subtotals, select Calculate Data Forms.
If the calculation is successful, the values in the Essbase database reflect the results of the calculation.
Related Topics: