Components of Rule Definition

A Rule is defined using existing metadata objects. The various components of a rule definition are as tabulated.

Table 10-1 Components in the Rule Definition and their Descriptions

Component Description
Dataset This is a set of tables that are joined together by keys. A dataset must have at least one FACT table. The values in one or more columns of the FACT tables within a dataset are transformed with a new value.
Source This component determines the basis on which a record set within the dataset is classified. The classification is driven by a combination of members of one or more hierarchies. A hierarchy is based on a specific column of an underlying table in the data warehouse model. The table on which the hierarchy is defined must be part of the selected dataset. One or more hierarchies can participate as a source as long as the underlying tables on which they are defined, belong to the selected dataset.
Target This component determines the column in the data warehouse model that will be impacted by an update. It also encapsulates the business logic for the update. The identification of the business logic can vary depending on the type of rule that is being defined.
Mapping This operation classifies the final record set of the target that is to be updated into multiple sections. It also encapsulates the update logic for each section. The logic for the update can vary depending on the hierarchy member/business processor used. The logic is defined through the selection of members from an intersection of a combination of source members with target members.
Node Identifier

This is a property of a hierarchy member. In a Rule definition, the members of a hierarchy that cannot participate in a mapping operation are target members, whose node identifiers identify them to be an ‘Others’ node, ‘Non-Leaf’ node or those defined with a range expression. Source members, whose node identifiers identify them to be ‘Non-Leaf’ nodes, can also be mapped.

For more information on Hierarchy properties, see Defining Business Hierarchies.

Note:

The hierarchies and their nodes/members that are displayed in the Hierarchy Browser window depend on the security mapper definition for the selected information domain. For more information, see Map Maintenance.