The HPM_STG_DRIVER table provides details about the driver for the selected stage, including driver type, formula and layer.
Dependencies: None
Table 15. HPM_STG_DRIVER
| Field | SQL Server Data Type | Oracle Data Type | Required | Description |
|---|---|---|---|---|
| id | identity | integer | Yes | Unique record ID |
| name | nvarchar (80) | varchar2 (80) | Yes | 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) | Yes | Type of driver:
|
| fixed_member | nvarchar (80) | varchar2 (80) | Member in the Measures dimension that corresponds to the standard driver measure “FixedDriverValue.” | |
| 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 the appropriate value to determine whether idle costs are allowed for this driver:
| |
| driver_basis_type | nvarchar (80) | VARCHAR2 (80) | Yes | Select the required driver basis:
Note: The Standard Basis driver cannot be used with Even or Percentage driver types. |
| priority | integer | integer | No | 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 highest priority is 1. Numbers need not be sequential. Drivers with the same priority are executed in no particular order. Only whole, positive numbers are valid. |
| last_upload_date | datetime | date | The date and time of the last import. | |
| exception | nvarchar (255) | varchar2 (255) | Message detailing errors that occurred during the import of this table. | |
| created_userid | nvarchar (32) | varchar2 (32) | Populated by the import program upon update. | The ID of the user who initiated the last import. |
| created_timestamp | datetime | date | Populated by the import program upon update. | The date and time of the last import. This value is populated by the import program upon update. |
| modified_userid | nvarchar(32) | varchar2 (32) | Populated by the import program upon update. | The ID of the user who modified the last import. |
| modified_timestamp | datetime | date | Populated by the import program upon update. | The date and time of the modified import. |