HPM_EXP_ASGN_RULE_SELECTION

The HPM_EXP_ASGN_RULE_SELECTION table stores details about the source stage and dimension members for a rule controlling the assignments for the selected stage.

Table 24. HPM_EXP_ASSGN_RULE_SELECTION

FieldSQL Server Data TypeOracle Data TypeDescription
application_namenvarchar (80)varchar2 (80)Name of the application
ididentityintegerUnique record ID
pov_dim1_member_namenvarchar (80)varchar2 (80)Name of the first dimension member in the selected point of view.
pov_dim2_member_namenvarchar (80)varchar2 (80)Name of the second dimension member in the point of view, if applicable.
pov_dim3_member_namenvarchar (80)varchar2 (80)Name of the third dimension member in the point of view, if applicable.
pov_dim4_member_namenvarchar (80)varchar2 (80)Name of the fourth dimension member in the point of view, if applicable.
layer_namenvarchar (80)varchar2 (80)Name of the selected layer for the point of view:
  • Cost (Default)

  • Revenue

    Note:

    Either the cost_layer, revenue_layer, or both is required.

src_stage_namenvarchar (80)varchar2 (80)Name of the source stage for the assignment rule.
src_dim1_member_namenvarchar (80)varchar2 (80)Name of the first dimension member in the source stage.
src_dim2_member_namenvarchar (80)varchar2 (80)Name of the second dimension member in the source stage, if available.
src_dim3_member_namenvarchar (80)varchar2 (80)Name of the third dimension member in the source stage, if available.
rule_namenvarchar (80)varchar2 (80)Name of the rule controlling the selected assignment. The rule must be present in the target database.