Hierarchy Management Interface Overview

This option is used to search for the hierarchy members.

How to Search for a Dimension Member?

To search for a dimension member, follow the steps below:

1. Navigate to Maintenance > Hierarchy > Hierarchy Management.
2. Click the down arrow in the Search box. Filter search options appear.
3. Select any of these options: Label (code + name), Code, Name, and IDX.
   
   
4. Enter the search criteria in the Search box and then click the search icon. The search results appear.
5. Use an advanced search to produce or narrow results. You can search using  Label, Code, Name, and IDX columns.
6. Click X to clear the search.

The hierarchy path is displayed based on where you navigate within a hierarchy. Click a member in the path and the parent member will be displayed in the left pane and the member itself will be displayed in the center pane as shown in the example below.

You can display members in the center pane by IDX, Code, and Name as shown below.

Sort members in the center pane in ascending or descending order. 

This option is to add a member to the hierarchy. Click here to learn more on how to add hierarchy members.

This option deletes a member in the hierarchy. Click here to learn how to delete a hierarchy member.

This option is used to cut and paste to move members around within a hierarchy. All you need to do is select the member and click Cut. Locate the place where you want the member and click Paste. Note that you must be in the Edit mode to perform the Cut/Paste action.

Select from the following:

• Show/Hide Properties (the right pane).
• Export the hierarchy to Excel in one of the following formats: Tree, Level-Based, Parent-Child, Leaf Level.
• Update Default View: To change the default view.
• Create Sibling Hierarchy: To create a sibling hierarchy. Click here to learn more. 

• Add
• Delete
• Cut/Paste

These are available for all members. Use the following Default Properties when adding, editing, and copying rollup and leaf-level members.

• Member Code: Enter a member code for the leaf-level node member or rollup node member.
• Member Name: Enter a member name for the leaf level node member or rollup node member.
• Parent Member: Displays the parent member of the node.
• Member Type: Displays the type of member: Rollup Node or Leaf Node.
• Member Sub Type: Displays the sub type of member. In Financial Hierarchies, the common subtypes for Rollup Node are Rollup Member, and the subtypes for Leaf Node is Leaf Member and Calculated Member. In Entity Hierarchies, the common subtypes for Rollup Node is Rollup Member, and the subtype for Leaf Node is the default budget entity hierarchy.
• Rollup Operator: Select an operator to use in performing rollup calculations. Available operators are Add (=), Subtract(−), Multiply(*), Divide(/), and None(∼).

These are available for leaf members. Options available are based on the segment.

• Account Group: Specify expense, asset, income, liability, statistical and/or equity for the selected account segment member.
• Credit/Debit: Specify credit or debit for the selected account segment member. This will affect reports.
• Account Type: Select Balance or Flow. Balance accounts start with previous year's ending balances and Flow accounts do not have any opening balances. Map Balance or Flow accounts to a selected account segment member.
• Currency Type: Select a defined currency type (created on the Currency Type page) to map to a selected account segment member.
• Normal Data Input Type: Select YTD or MTD to view accounts with a year-to-date or month-to-date input type. Map accounts to a selected account segment member. Generally, Income and Expense accounts are associated with MTD. Asset, Liability, and Equity Accounts are associated with YTD values. Statistical accounts can be set as either MTD or YTD.
• Variance Type: Select Positive or Negative. The variance is calculated as Actual vs Budget, Actual vs Forecast, Actual vs Plan. Map positive or negative variance accounts to a selected account segment member.
• Trial Balance Account: Select Yes or No. A trial balance is calculated by summing the balances of all the ledger accounts. Debits must equal credits in trial balance accounts. Map trial balance accounts to a selected account segment member.
• Report Category: A Report Category represents the desired level of a reporting view for consolidated segment members. These are used in standard reporting and help you categorize dimension/segment members. To create and map a Report Category: Click the Setup link under the Dimension/Hierarchy section in the left pane and select Report Categories on the Financial Hierarchies Setup screen.

Currency Property Changes made here will be reflected in the Planning templates where the dimension member is used. The template must be opened and closed (or processed via Simulation Engine) and the cube must be processed. Doing so recalculates the data according to the updated properties.

Source Properties are available when you are using a second set of books. See Multiple Set of Books. The Member Group field is used to group companies for processing purposes and the Source Company field is where you select the company where the data will be copied from in your IFRS hierarchy.