HPM_EXPD_CALCRULE_CALCMSRS

The HPM_EXPD_CALCRULE_CALCMSRS view retrieves details about the calculated measures rule.

Table 16-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.