Setting Up a Dated Hierarchy

When there are changes in company organizational structures, you may need to manage multiple versions of hierarchies that existed during different periods in time, and you may also need to generate reports using different versions of organizational hierarchies that represent different reporting positions of individual entities.

A Dated Hierarchy allows you to manage hierarchies based on periods, allowing you to create a new version of a hierarchy and take a snapshot of the existing version.

A few examples:

• Company 01 was part of a Parent group until December 2022, when it was moved to a different Parent group, and you need to generate reports using both Parent group hierarchy versions.
• Product 01 was part of a Product group until December 2022, when it was merged with a different Product group starting January 2023, and you need to generate reports using both versions of the hierarchies to understand the impact of the movement on the financials of the Product group.

Prerequisite

To add dated hierarchies, the Enable Dated Hierarchy option must be set to Yes on the Define Financial Segments Configuration task for the appropriate segments as shown below.

How to Add a Dated Hierarchy?

Once enabled, complete the following steps in the Hierarchy Management interface accessed by navigating to Maintenance > Hierarchy > Hierarchy Management. 

To add an attribute hierarchy to a dimension, follow these steps:

1. Navigate to Maintenance > Hierarchy > Hierarchy Management.
2. In the Hierarchy Selection section, select Finance Hierarchies from the Type drop-down list, and select a Dimension.
3. Click Setup.
   
   
4. On the Financial Hierarchies Setup page, click Add.
   
   
5. Select Dated Hierarchy from the Hierarchy Type drop-down.
   
   
6. Enter a name, display name, and description for the hierarchy.
   
   
7. Select the date the hierarchy will start and end.
8. Click Save. Notice the Dated Hierarchies defined below.
   
   
9. Edit the hierarchy by adding members as you would with any hierarchy.