I have an employee who was working in SREG and then transferred to SCTT (Capture Attached)
The table i have in my dashboard should show the latest status of the employee so I am getting this employee in SCTT but in the same row i need to present the previous Business Unit which is in this example SREG ( Capture 1 Attached)
The problem is if we filter to see only the employees in a specific Business Unit for example here in SCTT automatically the previous Business Unit will show Null which is a bit logical cz the record of SREG is dismissed when choosing SCTT. (Capture 2 Attached)
Any solution for this issue.
N.B : we are facing the same case on the security level. For example if we give a user access only on SCTT the previous Business Unit field will be always null.
Would it maybe be a solution to calculate the previous BU in the script, adding the value to a new field associated with the employee? This will also solve your section access issue, while a chart based solution (which I can think of) would not.
We still have the problem in the security cz our security is done by business unit.
will try to solve it and if we didn't found any solution i think i have to send u a mock app but this will take some time to adjust it. Is it helpfull if i opened the app without data and send it to you ?
I was thinking of such solution but in my case the business unit is found in organization table while all the employee data is in people table so i am not able to generate it in a simple way in the script.
you might give me an idea from your point of view.