Gross Pay Balance for full Fiscal Year for all Employees

Summary:

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

Person Number

Display Name

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