OTBI Report For Payroll Balance Results Retrieving Inception-to-Date Balances and Relationship Run

Summary:

We are using the OTBI report to validate employee balance results and identify remaining balances. However, the data displayed in OTBI is not synchronized with the employee balance results.

We have checked the employee balances using the Relationship Run Dimensions, but the employee balances are incorrect. The frontend UI shows a balance of 0, while the OTBI report displays a value of -27074.0. The OTBI results are incorrect, and we have attempted to look for the Assignment Inception to Date dimensions. However, we are unable to find that dimension in the subject area: Payroll - Payroll Balances Real Time.

 

We also attempted the following query: