Gross Pay Balance for full Fiscal Year for all Employees
I need to create or run a report for all employees to get the Gross Pay for each employee for our full Fiscal Year.
Format of data needed
Sum of Balance Value for Balance Name = "Gross Pay"
Where Balance Dimension = "Core Relationship Tax Unit Run"
and Payroll Period Start Date greater than or equal to DATE
and Payroll Period End Date less than or equal to DATE
Would the easiest way to obtain this data be:
Custom OTBI Analysis
Custom SQL Query (BIP Report/Data Model)
Seeded OTBI Analysis/Report/Dashboard
Seeded Payroll Flow/Report