The HPM_EXP_DRIVER table provides details about the driver for the selected stage, including driver type, formula and layer.
Table 21. HPM_EXP_DRIVER
| Field | SQL Server Data Type | Oracle Data Type | Description |
|---|---|---|---|
| application_name | nvarchar (80) | varchar2 (80) | Name of the application |
| id | identity | integer | Unique record ID |
| driver_name | nvarchar (80) | varchar2 (80) | Name of the driver. |
| description | nvarchar (255) | varchar2 (255) | Description of the purpose for the selected driver. |
| display_order | integer | integer | Display position of the driver within the list of all drivers in the model. |
| driver_type | nvarchar (80) | varchar2 (80) | Type of driver:
|
| complete_formula | nvarchar (500) | varchar2 (500) | Formula created for the driver by a user. This formula must be created using Essbase calculation script syntax. See the Oracle Hyperion Profitability and Cost Management User's Guide. |
| fixed_location | nvarchar (30) | varchar2 (30) | Location of the standard driver measure “FixedDriverValue.” |
| rate_member | nvarchar (80) | varchar2 (80) | Member in the Measures dimension that corresponds to the standard driver measure “Rate.” |
| rate_location | nvarchar (30) | varchar2 (30) | Location of the standard driver measure “Rate.” |
| weight_member | nvarchar (80) | varchar2 (80) | Member in the Measures dimension that corresponds to the standard driver measure “Weight.” |
| weight_location | nvarchar (30) | varchar2 (30) | Location of the standard driver measure “Weight.” |
| volume_member | nvarchar (80) | varchar2 (80) | Member in the Measures dimension that corresponds to the standard driver measure “Volume.” |
| volume_location | nvarchar (30) | varchar2 (30) | Location of the standard driver measure “Volume.” |
| custom_formula | nvarchar (500) | varchar2 (500) | Formula created for the driver by a user. This formula must be created using Essbase calculation script syntax. See the Oracle Hyperion Profitability and Cost Management User's Guide. |
| cost_layer | nvarchar (30) | varchar2 (30) | The driver layer is set to Cost layer, which contains the cost values for the model. Note: Either the cost_layer, revenue_layer, or both must be selected. |
| revenue_layer | nvarchar (30) | varchar2 (30) | The driver layer is set to Revenue layer, which contains the revenue values for the model. Note: Either the cost_layer, revenue_layer, or both must be selected. |
| allow_idle_cost | nvarchar (1) | varchar2 (1) | Enter appropriate value to determine whether idle costs are allowed for this driver:
|
| driver_basis_type | nvarchar (80) | VARCHAR2 (80) | Select the required driver basis:
Note: The Standard Basis driver cannot be used with Even or Percentage driver types. |
| priority | integer | integer | Enter the calculation priority of a driver so that allocations within a stage can be run in the specified order. The driver with the lowest priority is processed first. By default, the priority is set to 100, and the lowest (or first) priority is 0. Numbers do not have to be sequential. Drivers with the same priority are executed in no particular order. Only whole, positive numbers are valid. |