Reporting Tree

Context

The Reporting Tree feature provides you with a fast and flexible way to build financial Reports based on the structure and hierarchy of your company.

Although the main function of the Reporting Tree is the creation of financial Reports, it can be used in any other functional areas of your business (Sales, Logistics, Manufacturing, etc.). This allows you to build complex hierarchies composed of interrelated business units such as Departments, Cost Centers, Territories, and more.

This hierarchy is built through groups of Nodes that represent an organizational chart, in which each box defined reflects a user-defined context that rolls-up in a hierarchical way.

By selecting a Node (Filter), you can then view your Reports in a variety of ways, all from one place. The same logic applies when distributing the Reports; it will generate all the required versions of your Reports based on your hierarchical configuration in a single output.

Setting up the Security Level

The Reporting Tree features in Excel are available only if they have been enabled in the Roles:

1. In the Administration section , click on the Security drop-down menu in the left pane.
2. Select Roles.
3. In the upper right-hand corner, select General Roles in the Manage drop-down list.
4. Select the Role category (Basic, Security, Manager) you want to give access to the Reporting Tree.
5. Under the Excel Add-in section, tick the Reporting Tree options you want to grant to this Role category: Reporting Tree Selector, Reporting Tree Node Selector or / and Reporting Tree Duplicator.
   

To give a user access to the Reporting Tree feature for the Reports:

1. Under the Reports section, tick the Use filtering function checkbox.
   
2. Click on Apply changes to confirm.

Limiting access to the Reporting Tree

You can decide whether or not a user can build their own Reporting Tree by enabling this option:

1. In the upper right-hand corner, select General Roles in the Manage drop-down list.
2. Select SECURITY in the list.
3. Under the Administration section, tick the Manage Reporting Trees checkbox.
   
4. Click on Apply changes to confirm.

Creating a Reporting Tree

1. In the Administration section , click on Reporting Trees in the left pane.
2. In the left-hand corner, click on Add New Reporting Tree.
   
3. In the Reporting Tree field, enter a name for the Reporting Tree.
4. In the Filter drop-down lists, select the Global Parameters you want to use as Filters.

5. Click on Confirm to finish.

Adding Root Level Group and Level Filter

At the Level Group, the Filters you define are gathered on each level from the Root (Root Level Filter) into a group so that the hierarchy stays organized and easy to navigate. It is here that you create the Nodes that will compose your Reporting Tree.

1. In the Reporting Tree list, click on the wrench icon of the Reporting Tree you want to apply Filters to.
   
2. Click on Add Root Level Group to start defining the hierarchy of your Filters:
   
   1. In the Description field, enter a name for this group.
   2. In the second field, click on the paste icon to retrieve the value from the Description field or enter the name you want displayed in the tab of your Excel file.
   3. Tick the Distributable checkbox to make this Node and the Filters within this group available for the Distribution.
   4. Click on Save to finish the creation of your group.

3. Click on Add filter to add Filters to the Group you have just created:
   
   
   1. In the Description field, enter a name for this Filter.
   2. In the second field, click on the paste icon to retrieve the value from the Description field or enter the name you want to be displayed in the tab of your Excel file.
   3. Use the Prompt to select a value in the Global Parameters.
   4. Tick the Distributable checkbox to make this Node and the Filters within this group available for the Distribution.
   5. Click on Save to finish creating your Filter.
4. Click on Confirm to create your structure.

Editing Reporting Tree Filter Node

In the Reporting Tree window, click on Edit:

1. If needed, change the name of the Filter in the Description field.
2. In the second field, change the name that will be displayed in the tab (sheet) of your Excel file.
3. If needed, use the Prompt to select another value in the Global Parameters for the Filters.
4. If needed, tick or untick the Distributable checkbox to make this Filter Node available or unavailable to Distribution.
5. Click on Save to finish editing this Filter.
6. Click on Confirm to save your changes on the server.

Using the Reporting Tree in Reports

1. In the Reports tab, right-click on a Report and select Properties.
2. Under the Options section, select the Reporting Tree you defined in the drop-down list and click on OK.
   

3. Once the Report is loaded, click on Reporting Tree in the right pane to reveal the tree architecture.
   
4. In the Reporting Tree Filter panel, click on one of the nodes to retrieve data and refresh the Report.
   

Using the Reporting Tree in the Distribution

For any existing Views in Nectari, you can use the Scheduler to send the Reporting Tree to other users.

1. In the Administration section , click on Scheduler in the left pane.
2. Follow the procedure described in Creating a New Job.

Using Reporting Tree with Excel Add-In

Combined with Excel Add-In, the Reporting Tree allows you to quickly and easily generate several Reports based on specific Nodes, all gathered in one place.

Prerequisites

To use the Reporting Tree:

1. In the Excel file, click on Reporting Tree in the menu options to select the Reporting Tree from which to retrieve the Node. If you are not logged in (refer to Login to Nectari Excel Add-in ) a pop-up window will appear so that you may do so.
   
2. Click on OK.

3. Select the cell in the sheet to be used as Reference and click on Reporting Tree Node Selector in the menu options.
   
4. Select the Node from the Reporting Tree you want to retrieve the data. Here, we select the C4 cell and add a description in the B4 cell.
   
5. Click on OK.

Formulas

To create a Formula, select the cell you want to define a Formula for and follow the procedure described in Formula.

Refer to Nectari Formula Drill Down to use the Reporting Tree as a Filter to perform drill down.

Data Extraction

To perform a Data Extraction using the Reporting Tree, refer to Data Extraction.

Pivot Table

To create a Pivot Table using the Reporting Tree, refer to Nectari Pivot Table.

Open View and Data Entry

For these two features, the Reporting Tree will not be taken into consideration if the Formula is using the Reporting Tree Node as a Filter.

Clear Cache

To clear the cache of Excel Add-In using the Reporting Tree, refer to Clear Nectari Cache.

Reporting Tree Duplicator

The Reporting Tree Duplicator feature allows you to replicate the Reporting Tree structure by taking into account only the Nodes for which you had checked the Distributable checkbox (refer to Adding Root Level Group and Level Filter).

1. In the Worksheet, select the Reference Cell (refer to Prerequisites) and click on Reporting Tree Duplicator in the menu options.
2. In the Reporting Tree Node Cell field, the position of the Reference Cell should be filled in. If not, select the cell.
   
3. For the Duplicate By option, choose between Tab or Row.

If you choose Tab:

• One sheet per Node (the one with the Distributable checkbox ticked) will be created.
• The tab name will be the one you defined in the Administration screen of the Reporting Tree for these specific Nodes.
• The Description will change in the cell selected on each sheet as well as the ID of the Reporting Tree Node.
• The Formula that refers to the Reporting Tree Node will automatically be refreshed.

If you choose Row, the row will get repeated for each Node as well as the Formulas.

4. Click on OK to finish.