You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTBI Reports over Payroll Data

Received Response
28
Views
4
Comments
edited Jul 9, 2021 1:36PM in Reporting and Analytics for HCM 4 comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!