Launching Business Rules in Excel

Data source types: Planning, Financial Consolidation and Close, Tax Reporting

To launch a business rule in Excel:

Open an ad hoc grid or form (single or composite).
Save any unsaved data.

Unsaved data is lost when you launch a business rule.
From the provider ribbon, select Calculate, and then Business Rules.
From Business Rules, under Plan Type, select the cube associated with the rule you want to use.
Select a rule from the rules listed for that cube, and then click Launch.
Note:
- For business rules that include runtime prompts, enter the information described in Entering Runtime Prompts.
- For template-based business rules, you define rule parameters using a guided wizard.
- Planning only: Starting in Planning 20.03, users can add dynamic members, also known as "members on-the-fly," from Oracle Smart View for Office. To add dynamic members, manually type the new member name in the Runtime Prompts text box, and then click Launch.
If the calculation is successful, the values in the database reflect the results of the calculation.

Tip:

Administrators: During form design in Planning, rules with runtime prompts directly attached to a composite form with Run on Save enabled are not supported in Smart View. You should always attach rules to a simple form, enable Run on Save, then attach the business rules from the simple to the composite form. This way, all runtime prompt values are picked up correctly from the form context and the business rules launch successfully.
Click Close.
From the Smart View ribbon, select Refresh.