HPM_EXP_STAGE
The HPM_EXP_STAGE view retrieves the list of Stages defined within the model for all applications. This view also displays all the other attributes that are defined for the stage.
Table 8-1 HPM_EXP_STAGE
Field | SQL Server Data Type | Oracle Data Type | Description |
---|---|---|---|
application_name | nvarchar (80) | varchar2 (80) | Name of the application |
id | identity | integer(38,0) | Stage ID saved in the Oracle Hyperion Profitability and Cost Management database |
name | nvarchar (80) | varchar2(80 CHAR) | Name of the model stage. |
description | nvarchar (255) | varchar2(255 CHAR) | Brief explanation of the purpose of the stage. |
stage_order | integer | integer | The sequence position in which the selected stage is to be used within the model while modeling (assignments and rules creation), in calc script generation and calculation. |
stage_prefix | nvarchar (80) | varchar2(80 CHAR) | Differentiating prefix for the stage name. |
dim1_name | nvarchar (80) | varchar2(80 CHAR) | Name of the first dimension included in the stage. |
dim2_name | nvarchar (80) | varchar2(80 CHAR) | Name of the second dimension included in the stage, if available. |
dim3_name | nvarchar (80) | varchar2(80 CHAR) | Name of the third dimension included in the stage, if available. |
driver_dim_name | nvarchar (80) | varchar2(80 CHAR) | Name of the dimension selected as the driver for the stage. |
Is_intra | nvarchar (1) | varchar2 (1 CHAR) | Flag determining whether intrastage assignments are allowed:
|