HPM_EXPD_CALCRULE_CALCMSRS
The HPM_EXPD_CALCRULE_CALCMSRS view retrieves details about the calculated measures rule.
Table 14-8 HPM_EXPD_CALCRULE_CALCMSRS
| Field | SQL Server Data Type | Oracle Data Type | Description |
|---|---|---|---|
| application_name | nvarchar (80) | VARCHAR2(80 CHAR) | Name of the selected application |
| id | identity | NUMBER(38,0) | Unique identifier for each row. This can come from any sequence generator. |
| name | nvarchar (80) | VARCHAR2(80 CHAR) | Name of the calculation rule. |
| description | nvarchar (255) | varchar2(255 CHAR) | Long description of the calculation rule. |
| pov_dim1_member_name | nvarchar (80) | varchar2(80 CHAR) | Name of the first dimension member in the selected POV |
| pov_dim2_member_name | nvarchar (80) | varchar2(80 CHAR) | Name of the second dimension member in the selected POV |
| pov_dim3_member_name | nvarchar (80) | varchar2(80 CHAR) | Name of the third dimension member in the selected POV |
| pov_dim4_member_name | nvarchar (80) | varchar2(80 CHAR) | Name of the fourth dimension member in the selected POV |
| calculation_sequence | integer | NUMBER(4,0) | Numeric value designating the relative order in which the calculation rule will be processed during calculation. This must be > 0 or you will get a check constraint error during insert. |
| tag | nvarchar (255) | VARCHAR2(255) | Specify search tags for the calculation rule in this column. |
| enabled_flag | nvarchar (1) | VARCHAR2(1 CHAR) | |
| driver_name1 | nvarchar (1) | VARCHAR2(1 CHAR) | Driver name to be associated with this calculation rule. |
| driver_name2 | nvarchar (80) | VARCHAR2(80 CHAR) | Driver name to be associated with this calculation rule. |
| driver_name3 | nvarchar (80) | VARCHAR2(80 CHAR) | Driver name to be associated with this calculation rule. |
| driver_name4 | nvarchar (80) | VARCHAR2(80 CHAR) | Driver name to be associated with this calculation rule. |
| driver_name5 | nvarchar (80) | VARCHAR2(80 CHAR) | Driver name to be associated with this calculation rule. |
| dest_assign_rule_name1 | nvarchar (80) | VARCHAR2(80 CHAR) | Destination Assignment Rule to be associated with this calculation rule. |
| dest_assign_rule_name2 | nvarchar (80) | VARCHAR2(80 CHAR) | Destination Assignment Rule to be associated with this calculation rule. |
| dest_assign_rule_name3 | nvarchar (80) | VARCHAR2(80 CHAR) | Destination Assignment Rule to be associated with this calculation rule. |
| dest_assign_rule_name4 | nvarchar (80) | VARCHAR2(80 CHAR) | Destination Assignment Rule to be associated with this calculation rule. |
| dest_assign_rule_name5 | nvarchar (80) | VARCHAR2(80 CHAR) | Destination Assignment Rule to be associated with this calculation rule. |