HPM_EXP_POV
The HPM_EXP_POV view retrieves the states of each combination of dimension members included in a point of view (POV).
Table 8-2 HPM_EXP_POV
| Field | SQL Server Data Type | Oracle Data Type | Description |
|---|---|---|---|
| application_name | nvarchar (80) | varchar2(80 CHAR) | Name of the application |
| id | identity | integer(38,0) | POV dimension member group ID saved in Oracle Hyperion Profitability and Cost Management product database |
| pov_dim1_member_name | nvarchar (80) | varchar2(80 CHAR) | Name of the first POV dimension member. |
| pov_dim2_member_name | nvarchar (80) | varchar2(80 CHAR) | Name of the second POV dimension member, if available. |
| pov_dim3_member_name | nvarchar (80) | varchar2(80 CHAR) | Name of the third POV dimension member, if available.
Additional dimensions and member names may be added, as required. |
| pov_dim4_member_name | nvarchar (80) | varchar2(80 CHAR) | Name of the fourth POV dimension member, if available.
Additional dimensions and member names may be added, as required. |
| pov_state | nvarchar (80) | varchar2(80 CHAR) | The current status of the POV:
|