Configuring Org by Period in Dated Hierarchies

Dated Hierarchies work in conjunction with the Org by Period functionality. This functionality allows you to manage changes in organizational structure through an acquisition, disposal, or change of a parent company, and the associated changes for reporting and calculations.

• Acquisition: Set the period from when the newly acquired company is active in the present organization. The values of the company are reported based on the period of acquisition. Settings are specific to the scenario, and you can have different calculations for different scenarios.
• Disposal: Set the period when the Company is inactive (i.e., defunct). Values of the company are stopped from the period of disposal. Settings are specific to the scenario, and you can have different calculations for different scenarios.
• Change of Parent Organization: You can create a version of the hierarchy when the parent change occurs using a Dated Hierarchy. In this way, you can generate reports based on older, and newer, organizational structures.

You define the ownership changes of a company in the Ownership Changes pane. This allows you to define details of the change of Ownership - Acquisition Period (From), Disposal Period (To), and Ownership Changes.

How to Access the Org by Period Pane?

1. Navigate to Maintenance > Hierarchy > Hierarchy Management.
2. Select the hierarchy and click Show.
3. Select the impacted leaf node from the hierarchy.
4. Click the Org By Period link.
   
   

How to Configure Org By Period?

To configure the Org By Period option, do the following:

1. Navigate to Maintenance > Hierarchy > Hierarchy Management.
2. Select the impacted leaf node from the hierarchy.
3. Click the Org By Period link.
4. Select Enable Org by Period Calculations.
5. (optional ) Select the Change by Scenario to perform Org By Period calculations at the scenario level.
6. Enter appropriate active (From) and defunct (To) dates, as per the business case. For example: If the From date is set to Jan-24 and the To date is set to Mar-24, the start date of the calculation begins on the first day of Jan-24, and the end date is calculated on the last day of Mar-24.
   

There are two options under the Org By Period option. 

Understanding the Acquisition & Disposals Tab

The Acquisition & Disposals tab shows Scenario and dates of activity or inactivity, in the From and To fields, for the company. An Acquisition is the period from when the newly acquired company is active in the present organization. The values of the company are reported based on the period of acquisition. A Disposal is when the Company is inactive (i.e., defunct). Values of the company are stopped from the period of disposal.

Understanding the Ownership Changes Tab

Ownership Changes refer to periods when a company undergoes transitions in its ownership

The figure below shows a company that changed ownership from its parent company from May-21 to Apr-22, and then again from Apr-22 to Apr-23.

How to Generate Org By Period Report?

When generating reports at the parent level with Org By Period data, each child is shown under the respective parent. If a report is required for a specific company, select the main company, and in the reporting dimension, deselect the Org By Period reporting member.