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 |