Choose a rule set type

A rule set type in PerformancePoint Planning Business Modeler is a group of related business rules. Typically, a rule set contains one or more business rules, but a rule set can be empty. However, every rule must belong to a rule set, but you can create a rule while a rule set might contain no rules or multiple rules, a rule can only be located in a rule set. In addition, most rule sets can contain, or nest, other rule sets of the same type.

When you create a model, PerformancePoint Planning Server automatically creates a Definition, an Automatic, and a Variable rule set at the top level. User-created Definition, Automatic, or Variable rule sets must be nested in the corresponding system-generated rule set.

Different rule set types can contain different rule types. The rule type determines the options that you have for rule implementation. To learn more about rule types, see Analyze rule choices. To learn more about implementation options, see Analyze implementation options.

The following table lists the available rule set types that you can have, and notes the types of rules each can contain.

Rule Set Type

Description

Automatic

Planning Business Modeler runs these rule sets every time that the model reprocesses data. You can also execute these rule sets directly.
Permitted rules:     Assignment Rules
Implementation options:     SQL implementation, MdxQuery implementation, or Native code implementation (NativeSql or NativeMdxQuery)

Consolidation

A specialized rule set that contains only rules that calculate eliminations for a financial model with shares calculation. To run, include in a Consolidation job.
Permitted rules:     Consolidation Rules
Implementation options:    Specialized implementations(Consolidation)

Currency

A specialized rule set that contains only rules that perform currency translation . To run, include in a Currency Translation job.
Permitted rules:     Currency rules
Implementation options:     Specialized implementations(Currency)

Definition

A rule set that contains rules that must be calculated every time the model is deployed, and every time a cell in the rule scope is queried. To run, deploy the model.
Permitted rules:     Definition rules
Implementation options:     MdxScript implementation

InterCompany Reconciliations

A specialized rule set that contains only rules that eliminate transactions between sibling Entity members. To run, include in an Intercompany Reconciliation job.
Permitted rules:     Intercompany Reconciliation Rules
Implementation options:    Specialized implementations(InterCompany Reconciliation)

Outbound

A specialized rule set that contains only rules export data to an external destination. To run, include in a Data Export job.
Permitted rules:     Outbound Rules
Implementation options:    Specialized implementations(Outbound)

Procedural

A general purpose rule set. that can contain one or more of several different rule types: To run, execute directly, or include in a Calculation Rule job.
Permitted rules:     Allocation rules, Assignment rules, or Variable rules.
Implementation options:    SQL implementation, MdxQuery implementation, or Native code implementation(NativeSql or NativeMdxQuery) for all rule sets except Variable. Variable rules must have General implementations.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×