1. User Guide
  2. Business Rules Administration
  3. Allocation Specification
  4. Detail Screen
  5. Navigation in Detail screen
  6. Source Process Tab
  7. Source Dimension Container
  8. Mode Selection for a Dimension

3.8.2.1.3.2.1 Mode Selection for a Dimension

The Source Dimension Container grid contains a column called Mode that corresponds to the different modes of defining constraint to a dimension. The Mode displays a drop-down containing four modes – Macro, Leaf, Node and Hierarchy Filter.

The default mode for all dimensions is Macro and the default value for all dimensions is ALL. ALL means no constraint is applied to the dimension.

Leaf Mode must be used when you want to input a Leaf Value for a dimension. Once you select the Leaf Mode, the Value column drop-down is populated with all the leaf members available for the selected dimension. You can choose a member from the list of Leaf Members in the Value drop-down, or can type-ahead the required leaf member name in the Value Text Box. This free text type-ahead feature comes with Autosuggestion that creates a Dynamic List of values in the drop-down, matching the input string. If the Type-Ahead string does not match with a value from the drop-down list, the string will not be accepted.

Node Mode is to be used when you want to input a node value for a dimension. Once you select the Node mode, two things happen. First, the Selector Column drop-down is populated with all the Hierarchies available for that dimension and and the first Hierarchy in ascending alphabetical order of Hierarchy Name is selected as default in the Selector column. Second, the Value column drop-down is populated with all the node members applicable for the Hierarchy selected in the Selector column. This means the Value column drop-down displays all the node members available for the first Hierarchy (in ascending alphabetical order of Hierarchy Name) in the Selector.

Note:

If no hierarchy can be found for the dimension you have selected, the Selector column will be blank.

The Selector values appear as Folder name, hyphen and Hierarchy name for each of the hierarchies available for that dimension. The Folder name gives the name of the folder in which the displayed hierarchy is stored. You need to select one hierarchy from the Selector drop-down. This facilitates node member population in Value column dropdown, that are particular to that hierarchy. You can choose a member from the list of node members available in the Value drop-down, or type the required node member name in the Value text box. This free text type-ahead feature comes with Autosuggestion that creates a Dynamic List of values in the drop-down, matching the input string. If the type-ahead string does not match with a value from the drop-down list, the string will not be accepted.

Hierarchy Filter Mode is to be used when the user wants to apply a Hierarchy Filter constraint on a dimension. Hierarchy Filter mode works in similar fashion as that of Node mode. Once you select the Hierarchy Filter mode, the Selector Column drop-down is populated with all the available Hierarchies for that Dimension.

Note:

If no hierarchy can be found for the dimension you have selected, the Selector column will be blank.
The Selector values appear as Folder name, hyphen and Hierarchy name for each of the hierarchies available for that dimension. The Folder name gives the name of the folder in which the displayed hierarchy is stored. You need to select one hierarchy from the Selector drop-down. This facilitates Hierarchy Filter population in Value column dropdown, that are particular to that hierarchy.

Note:

If no Hierarchy Filter can be found for the Hierarchy you have selected, the Value column will be blank.

You can choose a hierarchy filter from the list of hierarchy filters available in the Value drop-down or can type-ahead the hierarchy filter in the Value text box. This free text type-ahead feature comes with Autosuggestion that creates a Dynamic List of values in the drop-down, matching the input string. If the type-ahead string does not match with a value from the drop-down list, the string will not be accepted.

The Selector is used for the Node mode and the Hierarchy Filter mode where selection of the Hierarchy is essential before selecting the node member or the hierarchy filter.

The Refresh button can be alternatively used to refresh and load the members in the Value column dropdown if the user faces performance issues with normal operation.

The Value column displays the value of a Macro, Leaf Member, Node Member, or a Hierarchy Filter. The member/filter value appears as Member Name, Hyphen and Member ID. You can choose a value from the list of values (that are essentially members and filters) in the Value drop-down, or can type-ahead the required member/filter in the Value text box. This free text type-ahead feature comes with Autosuggestion that creates a dynamic List of values in the drop-down, matching the input string. If the type-ahead string does not match with a value from the drop-down list, the string will not be accepted.

The Description Column displays the description of the member/filter selected in the Value column. The description includes information on the Dimension, Folder where the hierarchy is stored, the level of the member in the hierarchy, the member’s name, and the member ID.

Next comes the column that hosts the Hierarchy Browser Widget, clicking on which invokes the Hierarchy Browser. The Hierarchy Browser functionality differs across the various modes of constraint selection. The following section discusses more details.

The last column, the Hierarchy Member Filter Method is discussed in the next section, along with the Hierarchy Browser.

Source Scenario: For Allocation Rules that Source Data from the Management Ledger-level, you must select a Source Scenario from the Allocation Source Pane. The default for new Allocation Rules is <Use Application Preferences>. When you use this default value, the Scenario (also called Consolidation Code) is determined by the value that is set in Application Preferences for Profitability Management Cloud Service for the user who is running the rule. If you do not select <Use Application Preferences>, you must select a Defined Dimension Member Value (for example, Actual, Budget, Forecast, and Forecast Prior). These values are provided with the data model, but you may add additional Dimension Members in the Consolidation Code Dimension.

Table 3-11 Examples of using the Source Tab

Desired Data Constraint
Get all expenses for all GL Accounts within a specific Cost Center. Single-leaf constraint on Organizational Unit plus single-leaf constraint on Financial Element 457 – Non-Interest Expense.
Get all current mortgage balances for adjustable rate products originated in the past year. Hierarchy member constraint on the Product dimension plus a Data Filter constraint.
Get all initial General Ledger balances and all allocated balances for a specified set of Cost Centers for one GL Account. Single leaf constraint on General Ledger Account plus a Hierarchy member constraint on Organizational Unit.
Get ending balances for all balance sheet assets for the North, South, and East divisions (but not the West division except for the South-West sub-region). Single leaf constraint on Financial Element plus Hierarchy member constraint on the GL Account dimension plus an Organizational Hierarchy Filter.

The dimensions listed in the Allocation Source Pane are limited to your Key Processing Dimensions. The seeded Key Processing Dimensions for all OFS Analytical Applications are:

  • Financial Element
  • Organizational Unit
  • General Ledger Account
  • Common Chart of Accounts
  • Legal Entity Product