Some Elements are missing in OTBI
Summary:
I am preparing an OTBI report for employment verification, focusing on Gross Wages, Regular Wages, Overtime Wages, and Other Wages.
For Gross Wages, I'm currently using the following filter to ensure accuracy matching with the payslip:
FILTER("Balance Value"."Balance Value" USING ("Balance Types"."Balance Name" = 'Gross Earnings'))
However, when I aggregate all elements used in Regular, Overtime, and Other wages, I've noticed a slight variance in the total amount for some employees compared to the Gross Wages figure derived above.
Upon investigating further by checking the payslip of those employees for the respective pay period, I discovered that certain elements crucial for these calculations were missing from my report. I attempted to address this issue by running separate reports and try to find these missing elements using the following subject areas, but haven't been successful: