HPM_EXPD_STAGE
The HPM_EXPD_STAGE view retrieves the stage name and order, the application name, and the Source Stage and Destination Stage dimensions.
Table 14-1 HPM_EXPD_STAGE
| Field | SQL Server Data Type | Oracle Data Type | Description |
|---|---|---|---|
| application_name | nvarchar (80) | varchar2(80 CHAR) | Name of the selected application |
| id | identity | integer(38,0) | Stage ID that is used in the Oracle Hyperion Profitability and Cost Management database |
| name | nvarchar (80) | varchar2(80 CHAR) | Name of the selected Source stage |
| description | nvarchar (255) | varchar2(255 CHAR) | Description of the purpose for the selected stage |
| stage_order | integer | number (38,0) | 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. |
| driver_dim_name | nvarchar (80) | varchar2(80 CHAR) | Name of the selected driver dimension |
| Is_intra | nvarchar (1) | varchar2(1 CHAR) | Flag determining whether intrastage assignment are allowed:
|
| dim1_name | nvarchar (80) | varchar2(80 CHAR) | Name of the first dimension 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. |
| dim4_name | nvarchar (80) | varchar2(80 CHAR) | Name of the fourth dimension included in the stage, if available. |
| dim5_name | nvarchar (80) | varchar2(80 CHAR) | Name of the fifth dimension included in the stage, if available. |
| dim6_name | nvarchar (80) | varchar2(80 CHAR) | Name of a dimension in the Destination stage |
| dim7_name | nvarchar (80) | varchar2(80 CHAR) | Name of a dimension in the Destination stage |
| dim8_name | nvarchar (80) | varchar2(80 CHAR) | Name of a dimension in the Destination stage |
| dim9_name | nvarchar (80) | varchar2(80 CHAR) | Name of a dimension in the Destination stage |
| dim10_name | nvarchar (80) | varchar2(80 CHAR) | Name of a dimension in the Destination stage |
| dim11_name | nvarchar (80) | varchar2(80 CHAR) | Name of a dimension in the Destination stage |
| dim12_name | nvarchar (80) | varchar2(80 CHAR) | Name of a dimension in the Destination stage |
| dim13_name | nvarchar (80) | varchar2(80 CHAR) | Name of a dimension in the Destination stage |
| dim14_name | nvarchar (80) | varchar2(80 CHAR) | Name of a dimension in the Destination stage |
| dim15_name | nvarchar (80) | varchar2(80 CHAR) | Name of a dimension in the Destination stage |
| dim16_name | nvarchar (80) | varchar2(80 CHAR) | Name of a dimension in the Destination stage |
| dim17_name | nvarchar (80) | varchar2(80 CHAR) | Name of a dimension in the Destination stage |
| dim18_name | nvarchar (80) | varchar2(80 CHAR) | Name of a dimension in the Destination stage |
| dim19_name | nvarchar (80) | varchar2(80 CHAR) | Name of a dimension in the Destination stage |
| dim20_name | nvarchar (80) | varchar2(80 CHAR) | Name of a dimension in the Destination stage |
| dim21_name | nvarchar (80) | varchar2(80 CHAR) | Name of a dimension in the Destination stage |
| dim22_name | nvarchar (80) | varchar2(80 CHAR) | Name of a dimension in the Destination stage |
| dim23_name | nvarchar (80) | vvarchar2(80 CHAR) | Name of a dimension in the Destination stage |
| dim24_name | nvarchar (80) | varchar2(80 CHAR) | Name of a dimension in the Destination stage |
| dim25_name | nvarchar (80) | varchar2(80 CHAR) | Name of a dimension in the Destination stage |