5.3.1.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.
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.
Note:
If no hierarchy can be found for the dimension you have selected, the Selector column will be blank.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 5-10 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