Changes to the Organization dimension structure

Alternate hierarchy for the Organization dimension is created by Version control. This feature allows you to store different versions of the Organization hierarchy. The functionality is activated in Designer. Administrators can use version control to reflect changes in their organization structure. The previous versions of the Organization hierarchy are kept intact.

Workforce Planning reports include logic for selecting the correct hierarchy. Cube values are displayed using the Organization dimension hierarchy that is, or was, valid for a specific period. If the current period is selected in a Workforce Planning report, cube values are displayed using the default Organization hierarchy. If a past period is selected in a Workforce Planning report, cube values are displayed using the Organization hierarchy that was valid on the last day of the selected period.

Period selection in Workforce Planning reports

If, for example, there are three versions of the Organization hierarchy:

  • V20180531

    This version is valid through 31st May 2018.

  • V20180630

    This version is valid for 1st June 2018 through 30th June 2018.

  • VCURRENT

    This version is valid for 1st July 2018 through the current date.

Example1: A weekly period is selected

If the week of 7th May - 13th May 2018 is selected in the report, cube values are displayed using the V20180531 hierarchy. If the week of 28th May - 3rd June 2018 is selected in the report, cube values are displayed using the V20180630 hierarchy. If the week of 25th June - 1st July 2018 is selected in the report, cube values are displayed using the VCURRENT hierarchy.

Example 2: A monthly period is selected

If the period that is selected in the report is May 2018, or any previous period, cube values are displayed using the V20180531 hierarchy. If the period that is selected in the report is June 2018, cube values are displayed using the V20180630 hierarchy. If the period that is selected in the report is July 2018, or any following period, cube values are displayed using the VCURRENT hierarchy.

The same principle is applied to bi-weekly, quarterly, and yearly periods.