From Oracle Hyperion Enterprise Performance Management Workspace, select Navigate, then Applications, then Profitability, and then select the application for which you want to create the driver.
From Task Areas, select Manage Allocations, and then Driver Definitions.
In Driver Definitions, click the Add New Driver button.
In Name, enter a unique name for the new driver.
Caution:
Do not use special or restricted characters in the driver name, such as /,+, or @ signs, because doing so may cause import operations to fail. See the Oracle Essbase Database Administrator's Guide to view the latest restrictions.
Optional: In Description, enter a brief description of the purpose of the driver.
Under Write Result to Destination Measure, click the Browse button to select the Destination measure to which the driver will write the allocated values, and then click OK.
In Define Driver, under Operation Type, select Calculated Measure.
In Sequence Priority, enter the calculation priority as a positive integer. By default, 100 is displayed. The highest priority is 1.
Under Calculation Formula, enter the custom driver formula equation.
You can build the formula using both the keyboard and the Insert button.
To use the Insert Selector:
Click Insert to display the Insert selector for the available measures for the driver.
From the list, select Destination to display available Destination measures.
From the dimension list, select the measure for the formula.
Click OK.
After entering the formula, click Validate.
The SQL driver formula is validated, and a success message is displayed. Address any errors before proceeding.