Hi folks,
I have the task to model a HR - cube with some fact data.
One of the questions is:
How many hours a day a given person are “planned” or “normal workday” time?
The customer showed me the report “Personal Schedule” and I created some example data.
The report will give me explicit what I need:
This is the form of “plan” data I need.
EmpNo, Date, From, To, (Plan) Hours.
Later on I can compare the “plan” with the actual hours, like booked hours, even sick leave, customer visits, etc.
I traced the report to INFO_SERVICES_RPT and found the data the report is using.
I learned that RPT Tables are only for temporary data used for a specific report and are cleaned afterwards.
So is there another structure the report is fetching the data into the INFO_SERVICES_RPT?
Or is there a “master calendar”?
Hmm, I just checked on legal holiday like “Eastern” I saw that this personal schedule just show a normal work day.
Any hints are highly welcome.
all the best and stay safe.
Michael
