HPM_EXP_ASGN_RULE_SEL
The HPM_EXP_ASGN_RULE_SEL view retrieves details about the source stage and dimension members for a rule controlling the assignments for the selected stage.
Table 8-7 HPM_EXP_ASGN_RULE_SEL
| Field | SQL Server Data Type | Oracle Data Type | Description |
|---|---|---|---|
| application_name | nvarchar (80) | varchar2 (80) | Name of the application |
| id | identity | integer(38,0) | Unique record ID |
| pov_dim1_member_name | nvarchar (80) | varchar2 (80) | Name of the first dimension member in the selected point of view. |
| pov_dim2_member_name | nvarchar (80) | varchar2 (80) | Name of the second dimension member in the point of view, if applicable. |
| pov_dim3_member_name | nvarchar (80) | varchar2 (80) | Name of the third dimension member in the point of view, if applicable. |
| pov_dim4_member_name | nvarchar (80) | varchar2(80) | Name of the fourth dimension member in the point of view, if applicable. |
| layer_name | nvarchar (80) | varchar2(80) | Name of the selected layer for the point of view:
|
| src_stage_name | nvarchar (80) | varchar2(80) | Name of the source stage for the assignment rule. |
| src_dim1_member_name | nvarchar (80) | varchar2(80) | Name of the first dimension member in the source stage. |
| src_dim2_member_name | nvarchar (80) | varchar2(80) | Name of the second dimension member in the source stage, if available. |
| src_dim3_member_name | nvarchar (80) | varchar2(80) | Name of the third dimension member in the source stage, if available. |
| rule_name | nvarchar (80) | varchar2(80) | Name of the assignment rule controlling the selected assignment source combination. The Assignment Rule should already be defined in the Oracle Hyperion Profitability and Cost Management database. |