OTBI Reports over Payroll Data

Summary

We experience terrible performance when we run OTBI reports over subject areas such as Payroll Balances Real Time

Content

The OTBI reports tool is struggling to provide data over Subject Areas such as Payroll Balances Real Time. Our users are trying to run summary info for periods that may span a year and are experiencing run times over 10 hours or more.

Note we have 20,000 employees and 52 payrolls a year. With simple math (looks like about 450+ records per employee per week) that puts us at about 450,000,000 records for a year's worth of data.

We find that unacceptable and would like to get some guidance.