HPM_EXP_ASSIGNMENT
The HPM_EXP_ASSIGNMENT view retrieves details about each assignment, including the source stage, POV, layer, source dimension members, destination stage, and destination dimension members.
Table 8-6 HPM_EXP_ASSIGNMENT
| Field | SQL Server Data Type | Oracle Data Type | Description |
|---|---|---|---|
| application_name | nvarchar (80) | varchar2 (80) | Name of the application |
| id | identity | integer(38,0) | Assignment ID saved in Oracle Hyperion Profitability and Cost Management database |
| 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. |
| 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. |
| dst_stage_name | nvarchar (80) | varchar2 (80) | Name of the destination stage for the assignment. |
| dst_dim1_member_name | nvarchar (80) | varchar2 (80) | Name of the first dimension member in the destination stage. |
| dst_dim2_member_name | nvarchar (80) | varchar2 (80) | Name of the second dimension member in the destination stage, if available. |
| dst_dim3_member_name | nvarchar (80) | varchar2 (80) | Name of the third dimension member in the destination stage, if available. |