13.3.1.2.5 Hierarchy Browser on the Source Tab

The default for each dimension is <All> (meaning no constraint). To select a constraint, click on the Hierarchy Browser ellipses (…) next to the dimension you wish to constrain.

Figure 13-13 Hierarchy Definition for Organization Unit Dimension Type


The Hierarchy Browser defaults to a list of leaves for the dimension you have chosen (the radio button selector near the top of the browser window defaults to Dimension Leaf Member). You may scroll up and down to find the leaf member you want or you may search for the member's name (short description) using the binoculars icon on the browser window.

The Hierarchy Browser defaults to a list of leaves for the dimension you have chosen (the radio button selector near the top of the browser window defaults to Dimension Leaf Member). You may scroll up and down to find the leaf member you want or you may search for the member's name (short description) using the binoculars icon on the browser window. Additional search functionality is provided by the Search icon. This additional functionality allows you to search by Dimension Member, Name, or Code.

Figure 13-14 Hierarchy Definition for Common Chart of Accounts Dimension Type


In the Hierarchy Browser window, select Common Chart of Accounts as the Dimension to see the orphan branches available that you want use.

To constrain your source using a hierarchy rollup point, click Hierarchy, and search for the hierarchy you wish to use. After your chosen hierarchy is displayed within the browser window, navigate to the hierarchy until you have found the rollup point or leaf value you want. Select the value and click OK.

Figure 13-15 Hierarchy Definition


After your have chosen hierarchy is displayed within the browser window, navigate to the hierarchy until you find the rollup point or leaf value you want. Select value and click OK.

To constrain your source using a Hierarchy Filter, select Hierarchy, and search for the type that supports the Hierarchy Filter you wish to use. Click Hierarchy Filter, search for the filter type you wish to use and click OK.

When the source table is Management Ledger and the allocation type is either Static Driver or Dynamic Driver, you can select a hierarchy member with additional options. You can select the hierarchy member by selecting any of the four “Hierarchy Member Filter Method” of (1) Node Only, (2) Last Descendants Of, (3) Descendants Of, or (4) Node and Descendants Of. This selection is applied at the per-dimension level of the source dimensions, meaning you have the liberty to select the “Nodes Only” filter method for the General Ledger dimension while applying a “Last Descendants Of” filter method on the Organization unit dimension.

The T2T that loads data from Staging to Management Ledger supports loading data to any kind of member in the Management Ledger – leaf-level members or node level members, rendering the user to select any of the two kinds of the member from the UI.

  • If you choose the hierarchy member filter method as "Nodes Only", only the node member is selected in the filter.
  • If you choose the hierarchy member filter method as "Last Descendants Of", only the leaf members of the hierarchy rolling up to the selected node are selected in the filter.
  • If you choose the hierarchy member filter method as "Node and Descendants Of ", all the descendant nodes and leaves of the selected node in the hierarchy including the selected node itself, are selected in the filter.

If you choose the hierarchy member filter method as "Descendants Of ", all the descendant nodes and leaves of the selected node in the hierarchy but excluding the selected node itself are selected.

Other Filters Pane

You may optionally select one filter among the following, to further constrain your Source data:

  • Data Filter
  • Group Filter
  • Attribute Filter
  • Data and Attribute Filter, or
  • Group and Attribute Filter

On selection of “Data and Attribute Filter”, two mandatory rows appear for filter selection – one for Data Filter selection and the other for Attribute Filter selection. You need to specify the filter folder names and the filter names for each type of filter. The selection of this type of filter instructs the PFT Allocation engine to apply both the data filter and the attribute filter simultaneously in the source data selection.

Similarly, on the selection of the Group and Attribute Filter – one mandatory row appears for Group Filter selection and the other mandatory row appears for Attribute Filter selection. This filter selection instructs the PFT Allocation engine to apply both the group filter and the attribute filter simultaneously in the source data selection.