Working with Assignment Rules

Assignments specify where allocation results are directed. Frequently, models include multiple assignments that use the same parameters. To simplify the creation of multiple assignments that are similar in nature, you can create and reuse assignment rules that specify the assignment parameters.

An assignment rule is a collection of member sets and optional filter sets for a single destination stage. A filter is a collection of criteria that are applied to a dimension. The rules are created based on one or more of the following criteria:

The destinations returned by an assignment rule are the cross-product of the Level-0 members from all the dimensions in the destination stage, that pass the filter criteria applied to the rule.

While the assignment rules reduce the effort of creating and maintaining many individual assignments, they also react to metadata changes over time, so that the original business logic captured in the rule definition continues to generate correct assignment relationships.

You can create assignment rules, using the following options:

Within a model, the definition of an assignment rule is the same in all POVs. Assignment rule selections can be imported into Profitability and Cost Management, using the HPM_STG_ASGN_RULE_SELECTION staging table. For instructions on using staging tables, see Appendix A in the Oracle Hyperion Profitability and Cost Management Administrator's Guide.

Two options are available to create and manage assignment rules, as follows: