Hierarchy Management Interface

This option is used to search for the hierarchy members.

To search for a user information, follow the steps below:

1. Click the down arrow in the Search box. Filter search options appear.
2. Select any of these options: Label (code + name), Code, Name, and IDX.
   
   
3. Enter the search criteria in the Search box and then click the search icon. The search results appear.
4. Use an advanced search to produce or narrow results. You can write a query using Type, IDX, Label, Code, and Label columns with the operators (<, >, =, != ), and use the keyword And. For example, if you want to search for rollup nodes "Label1" and "Label2," the query you would input is Label=Label1 AND Label=Label2
5. Click X to clear the search.

Locate

When you search a hierarchy for a member, you can use the Locate button to display the location of a selected member within the hierarchy. The parent member is displayed in the hierarchy in the left pane, the member is displayed in the center pane, and the member’s properties are displayed in the right pane.

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, Name, and/or Label 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.

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 only subtype for Rollup Node is Rollup Member, and the sub types for Leaf Node is Leaf Member and Calculated Member. In Entity Hierarchies, the only sub type for Rollup Node is Rollup Member, and the sub type 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(*), and Divide(/).

These are available for leaf members. Options available are based on 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. If your report displays negative numbers, you must change this property.
• 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 - Budget or Forecast. 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: Each report category represents the consolidated segment members' desired level of a reporting view. Report categories are used in standard reporting. Map the Report Category. Report Categories help you to categorize dimension/segment members and are created by clicking the Setup link under the Dimension/Hierarchy in the left pane. Then, under More, select Report Categories.

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.