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

Is the 75000 row limit for OTBI reports just a limit on the output?

in Reporting and Analytics for ERP 2 comments

For an OTBI report, the SQL automatically adds "FETCH FIRST 75001 ROWS ONLY." Is this only referring to the output of the report? Or is it also referring to the total population of records that the report queries?

For example, if we have 100,000 cash transactions and we add a filter to the report that results in 50 transactions, is the OTBI report still looking through all 100,000 cash transactions to result in the 50 transactions? Or is it only looking through the first 75,000 rows of the 100,000 transactions?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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