Working in the Hierarchy Management Interface

Panes

Hierarchy Management is made up of 3 panes (left, center, and right).

• The left pane is where you select the hierarchy you want to work with. It is also where the hierarchy is displayed.

• The center pane is where the contents of a rollup member or the leaf level members are displayed.

• The right pane is where properties are displayed for leaf members. It is also where you define/set/apply properties for each member, including; default properties, segment properties and user defined attributes.

Top Ribbon Icons/Functionality

Search

Hierarchy Path

Show / Hide Columns

Sort

Add

Cut / Paste

Copy

More

Search

Search for hierarchy members.

To perform a basic search:

1. In the Search box, click the down arrow. Filter search options appear.

2. Select from: Label (code + name), Code, Name, and IDX.

3. Enter search criteria in the Search box and then click the magnifying glass icon. The search results appear.

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

X - click to clear the search.

Locate Results Display

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 displays in the hierarchy in the left pane, the member displays in the center pane, and the member’s properties display in the right pane.

In Practice

1. Access Hierarchy Management by navigating to Maintenance > Hierarchy > Hierarchy Management.

2. Perform a search. In this case, ot is entered in the Search field. Results are displayed.

   

3. Select a member. In this case 010A-Hot Ltd-BE is selected.

4. Click the Locate button. Results display with the parent member highlighted in blue in the left pane, the member highlighted in blue in the center pane, and properties are displayed in the right pane as shown below. Also, the Search field remains populated with the data entered when the search was performed.

   

Hierarchy Path

The hierarchy path is displayed based on where you navigate within a hierarchy. In the example below, the following hierarchy path is displayed:

Company > Company Main > 010A - Hot Ltd - BE > 016A - HOT UK Ltd

Click a member in the path and the parent member will be displayed in the left pain and the member itself will be displayed in the center pane. For example, using the scenario above, if 010A-Hot Ltd-BE is clicked, the parent member of 010A-Hot Ltd-BE displays in the left pane.

Show/Hide Columns

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

Sort

Sort members in the center pane in ascending or descending order. Click OK when the Sortand Update dialog appears.

Understanding the Difference between a Rollup Node and a Leaf Node

Rollup Node functions are different from Leaf Node functions. Leaf Node is the last level in a hierarchy and data can be loaded to leaf nodes. The data loaded to the leaf is rolled up to the leaf node's rollup member.

Cut / Paste

Use cut and paste to move members around within a hierarchy. Select the member, click Cut. Locate the place where you want the member and click Paste.

Copy

Use Copy to make a duplicate of a selected member.

More

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.

Show/Hide Columns

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

Sort

Sort members in the center pane in ascending or descending order. Click OK when the Sort and Update dialog appears.

Understanding the Difference between a Rollup Node and a Leaf Node

Rollup Node functions are different from Leaf Node functions. Leaf Node is the last level in a hierarchy and data can be loaded to leaf nodes. The data loaded to the leaf is rolled up to the leaf node's rollup member.

Cut / Paste

Use cut and paste to move members around within a hierarchy. Select the member, click Cut. Locate the place where you want the member and click Paste.

Copy

Use Copy to make a duplicate of a selected member.

More

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.

Show/Hide Columns

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

Sort

Sort members in the center pane in ascending or descending order. Click OK when the Sort and Update dialog appears.

Add

Click the Add icon to add a member to the hierarchy.

Add a Rollup Member:

1. Access the Hierarchy Management page by navigating to Maintenance >Hierarchy >Hierarchy Management.

2. Ensure Hierarchy Management is opened in Edit mode.

3. Under Hierarchy Selection, select Type, Dimension, and Hierarchy and click Show.

4. In the hierarchy tree, select the desired member location.

5. Click Add.

6. Select Rollup Node from the Node Type drop-down list. For Rollup Node, you can only create a Rollup Member Node Sub Type.

7. Click Add.

8. Complete required fields (i.e. Default Properties).

9. Click OK.

10. Click Save.

Add a Leaf Level Member:

1. Access the Hierarchy Management page by navigating to Maintenance >Hierarchy >Hierarchy Management.

2. Ensure Hierarchy Management is opened in Edit mode.

3. Under Hierarchy Selection, select Type, Dimension, and Hierarchy and click Show.

4. In the hierarchy tree, select the member location.

5. Click Add.

6. Select Leaf Node from the Node Type drop-down list. If you are adding a leaf level member in Financial Hierarchies, select Leaf Member or Calculated Member from the Node Sub Type drop-down list. If you are adding a level member in Entity Hierarchies, the default budget entity hierarchy selected in the Node Sub Type drop-down list.

7. Complete all the required fields (for example; Default Properties and Segment Properties).

8. Click OK.

9. Click Save.

In addition to adding a rollup member and /or leaf member, you can edit and delete each of these members. Information on how to do so is provided below.

Edit

Edit a Rollup Member:

1. Access the Hierarchy Management page by navigating to Maintenance >Hierarchy >Hierarchy Management.

2. Open Hierarchy Management in Edit mode.

3. Under Hierarchy Selection, select Type, Dimension, and Hierarchy and click Show.

4. In the hierarchy tree, select the immediate parent member of the rollup member.

5. In the middle pane, select the rollup member. If the properties panel is not visible, click More, and then click Show/Hide Properties.

6. Edit the properties as needed.

7. Click OK.

8. Click Save.

Edit a Leaf Level Member:

1. Access the Hierarchy Management page by navigating to Maintenance >Hierarchy >Hierarchy Management.

2. Open Hierarchy Management in Edit mode.

3. Under Hierarchy Selection, select Type, Dimension, and Hierarchy and click Show.

4. In the hierarchy tree, select the immediate parent member of the leaf level member.

5. In the middle pane, select the leaf level member. If the properties panel is not visible, click More, and then click Show/Hide Properties.

6. Edit the properties as needed.

7. Click OK.

8. Click Save.

Delete

Delete a Rollup Member:

1. Access the Hierarchy Management page by navigating to Maintenance >Hierarchy >Hierarchy Management.

2. Open Hierarchy Management in Edit mode.

3. Under Hierarchy Selection, select Type, Dimension, and Hierarchy and click Show.

4. In the hierarchy tree, select the immediate parent member of the rollup member.

5. In the middle panel, select the rollup member.

6. Click Delete.

7. In the message that appears for confirmation, click OK.

Delete a Leaf Level Member:

1. Access the Hierarchy Management page by navigating to Maintenance >Hierarchy >Hierarchy Management.

2. Open Hierarchy Management in Edit mode.

3. Under Hierarchy Selection, select Type, Dimension, and Hierarchy and click Show.

4. In the hierarchy tree, select the immediate parent rollup member of the leaf level member.

5. In the middle pane, select the leaf level member.

6. Click Delete.

7. In the message that appears for confirmation, click OK.

Exploring the Left Pane - Entity and Finance Hierarchy Setup

The left pane is where you will select a hierarchy type (for example, Entity or Finance) to display, the dimension, and the associated hierarchy. It is also where the selected hierarchy is displayed.

There are two links under Hierarchy selection; Show and Setup.

The Show link displays the hierarchy you select.

The Setup link takes you to application pages that support all functionality related to the set up of your hierarchy.

Exploring the Right Pane - Member Properties

This is where properties for each dimension member in the hierarchy are displayed. If you are adding members, it is where you will select/enter properties.

• Default properties are available for all members.
• Segment properties are available for leaf members.
• User-Defined properties are specific to each application.

Exploring the Right Pane - Default Properties

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 sub type 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(/).

Exploring the Right Pane - Segment Properties

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 will need to change this property.

Account Type - Select Balance or Flow. Balance accounts start with previous year 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 and 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 a desired level of a reporting view of the consolidated segment members. 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. And then, under More, selecting Report Categories.

Exploring the Right Pane - User-Defined Attributes

Displays the available attribute selections defined for the selected member.