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.

Example

Let’s say that your company (the headquarters) has its departments located in different countries and that these departments have their own subsets.

In this example, Conso is the name of the headquarters (and because we plan to consolidate data in this report), North America and Europe are the location of the departments, NA10, NA20 and France are their subsets (children).

A visual representation of this:

Thanks to the Reporting Tree, you don't need to manually create a Filter for each subset (NA10, NA20, France). The parent folder (Group Node) simply uses the filter data contained in its children (Filter Node).

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.
Important

Make sure that the user you are granting access to the Reporting Tree to is also set to the same Role category. Refer to Users for more details.

Note

The first time the user opens a workbook in Excel, the three Reporting Tree options will be clickable. Depending on the one you enabled in the Administration, other options will become greyed out.

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.
Note

If not ticked, the Reporting Tree feature in the Report properties will become greyed out and the Reporting Tree option on the right pane will be hidden (refer to Using the Reporting Tree in Reports).

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.
Note

The Global Parameters you define here will be used as values when you add a Root Level Filter.

  1. Click on Confirm to finish.
Note

Click on the pencil icon to edit an existing Reporting Tree or on the cross icon to delete one.

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.
Note

If needed, you can add a Group inside a Root Level Group by clicking on Add Group.

  1. 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. Select the Distributable option to make this Node and the Filters within this group available for the Distribution.
    5. Click on Save to finish creating your Filter.
  2. Click on Confirm to create your structure.
Example

Editing Reporting Tree Filter Nodes

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.
Note

If you choose to edit a Reporting Tree Group Node, you will only be able to change the Description name and the one used in the tab (sheet) of your Excel file.

Tip  

You can restructure Reporting Tree filters and groups in the Manage Nodes menu by simply dragging and dropping them in the desired location. Both filters and groups can be re-ordered within their current structure level or moved to a parent or child level using this method. However, please note that a group cannot be placed within itself.

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.
Note

To deactivate the filtering based on the Reporting Tree, select None in the drop-down list.

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

If you select a Group Node , (those represented by a +/- sign), it will automatically include its children (i.e. all the sub-groups and Filters inside the sub-groups below this group).

Tip

For the title of your Report, you can use the Dynamic Variables drop-down list to select your Reporting Tree. Using variables will automatically change the main title of your Report when you select different Nodes. Refer to Report Title for more details.

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.