1. Administrator's Guide
  2. Working with Standard Profitability
  3. Exporting Model Definition Data for Standard Profitability
  4. HPM_EXP_DRIVER

HPM_EXP_DRIVER

The HPM_EXP_DRIVER view retrieves the details about the driver, including driver type, formula and layer.

Table 8-3 HPM_EXP_DRIVER

Field SQL Server Data Type Oracle Data Type Description
application_name nvarchar (80) varchar2(80 CHAR)

Name of the application
id identity integer

Driver ID saved in Oracle Hyperion Profitability and Cost Management database

driver_name nvarchar (80) varchar2(80 CHAR)

Name of the driver.
description nvarchar (255) varchar2 (255 CHAR)

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 CHAR)

Type of driver:

  • Even

  • Simple

  • Simple Weighted

  • Simple Variable

  • Weighted Variable

  • Fixed and Variable

  • Percentage

  • Custom
complete_formula nvarchar (500) varchar2 (4000 CHAR)

Formula created for the driver by a user or a translated fromula for pre-defined driver types. This formula must be created using

Oracle Essbase calculation script syntax. See the Oracle Hyperion Profitability and Cost Management User's Guide.
cost_layer nvarchar (30) varchar2 (3 CHAR)

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 (3 CHAR)

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 CHAR)

Flag determining whether idle costs are allowed for this driver:

  • "Y" (Yes) specifying idle costs are allowed for this driver.

  • "N" (No) specifying idle costs are not allowed for this driver.

driver_basis_type nvarchar (80) varchar2(80 CHAR)

Select the required driver basis:

  • Actual Basis

  • Standard Basis

Note: The Standard Basis driver cannot be used with Even or Percentage driver types.

priority integer integer(38,0)

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.