Payroll Balance Duplicating with Multiple Assignments

Content

Hi,

I am trying to write a report in OTBI to pull Gross Earnings in a specific time period, and I am running into a problem where the amount is duplicating in some instances when individuals have multiple assignments that were active at the same time.

Subject Area: Payroll - Payroll Balances Real Time

Columns:

• "Payroll - Payroll Balances Real Time"."Balance Dimension"."Base Dimension Name"
•    "Payroll - Payroll Balances Real Time"."Balance Types"."Balance Reporting Name"
•    "Payroll - Payroll Balances Real Time"."Payroll"."Payroll Period Name"
•    "Payroll - Payroll Balances Real Time"."Worker"."Assignment Category"
•    "Payroll - Payroll Balances Real Time"."Worker"."Employee Name"