Defining Drivers and Formulas for Detailed Profitability

Drivers are used to control allocations between objects in a Detailed Oracle Hyperion Profitability and Cost Management model.

Drivers work with Assignments, source data, and driver data to build a complete set of instructions and data to control system calculations.

While assignments direct the data from a source to a destination, the drivers that are associated with these assignments are used to calculate the value of the allocations. The drivers provide the formulas for allocating source values to destinations. Driver measures and formulas promote model flexibility by enabling you to use variables to represent model elements, and mathematical operands to calculate driver values. Drivers are not directly associated with stages.

Note:

If a driver used in the allocation is modified or deleted, you must recalculate the model.

For each driver required in the model, perform these tasks:

• Determine which types of drivers you require for the application. Driver Operation Type defines the type of the driver as rate-base, ratio-based, or as calculated measure. See Defining Detailed Profitability Drivers.

• Generate driver formulas based on SQL-syntax. See Driver Formulas.

• If you want to run drivers in a specific sequence, see Driver Priority Sequence.

• Define the new driver and the associated formula. See Defining Detailed Profitability Drivers.

• Associate the driver with the selected measure. See Working with Detailed Profitability Drivers.