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.
Optional: Filter rules by cube and rule type.

All cubes and rule type options are selected by default. To narrow the search, clear the check boxes for cubes and rule types that you do not need to see. The list is filtered according to your selections. For example, selecting only Plan1 and all Rule Types, we would see business rules of all types that apply to only the Plan1 cube.
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.