Log In
Register
Home
New Member
Dashboards
Power Query
Power Pivot
Power BI
August 19, 2022
Offline
Hi Experts,
In my Org. we're using two LMS systems (Oracle LMS -entries entered manually for purpose of trackingand it's linked to payroll- & SAP Success Factor -main LMS system in use and auto update entries-) been informed that Oracle entries are not matching SAP records so there is missing in entires in report from 01.01.2022 to 10.12.2022
How I can check specially a lot of employee IDs is repeated as they could have done more than one training (multiple transactions per ID)
Number of rows in Oracle report (which missing entries) is even more than number of rows in SAP report which is rigid.
I have current employee list from payroll, but some employees has left business since Jan 2022 so their IDs might appear in Orcale / LMS reports but not in current employee list.
December 13, 2021
Offline
If you may post a sample of the layout files that would be helpful in solving it.
New Member
Dashboards
Power Query
Power Pivot
Power BI
August 19, 2022
Offline
@MGB
Attached
December 13, 2021
Offline
Hi R.A.
Please, some extra questions:
- Which file was generated from the Oracle system? is it OLM-01012022-05122022-1.xlsx (659 KB)?
- Regarding the date you mentioned, is it the 12th of October, or the 10th of December because the earlier one is 01.01.2022?
- Are employees that left the business those who have Ex-employee under the Person Type column in the file OLM-01012022-05122022-1.xlsx?
- Pending Termination under the Assignment Status in the file Employee-list-NOV2022.xls, are they regular employees?
Also after a quick scan of the data, I've found some changes as shown in pictures.
The reason for my questions is to know the main starting point for comparing and building on it.
Thanks
MGB
December 13, 2021
Offline
Hi,
The data is really not clean.
The only column that may be used is the employee ID.
The training name is not titled the same in both sheets, but sometimes it is titled followed by month and others without it, and for those that include the month name, the name of the month sometimes is the full name and other times not.
The suggested solution from my side is attached.
It takes a lot of manual work indeed, and so far I've spent 4 hours working on it.
I am not an expert with Excel but this is the best I can do.
You can continue what I did, or maybe some other members have an advanced solution for your issue like a formula that collects and match.
Good luck.
1 Guest(s)
