Dealing with monthly Dinamic Hierarchies.

rodolfo.hernandez
rodolfo.hernandez
in Modeling

Hi, I would like to hear from the community if you have dealt with the same issue that I have and how you solved it. The issue is as follows:

I have 2 lists:

  1. Cost Center (with selective access enabled, so an owner can access only one Cost Center)
  2. Employee (Employee is a child of the Cost Center list)

The problem is that an "Employee" is not static all the time; he or she can change the Cost Center parent from month to month. For example:

Employee Jan Feb Mar Apr
001 Finance Finance Commercial Commercial

As you can see, Employee 001 changed from Finance to Commercial in March.

The issue is that the Finance owner should be able to see the historical data for Employee 001 up to February, and the Commercial owner should see Employee 001 starting from March. (Remember that the access to the employee depends on parent selective access.)

if they were a few changes it could be Managed manually by renaming and creating new codes but now lets figurate this with a large number of data and changes.

how would you solve this?

I would really appreciate your help.

Answers

Categories