OTBI Pivot table limits number of rows

Arnabb

Hi,

I have an OTBI report for Total Comp Deferred Cash Payments year wise. This is a simple report from subject area - Payroll - Element Entries History Real time. We are pulling total amount of Element entries per year as per Payment Date.

Issue is, the report table pulls correct information but when we include Pivot Table, it limits the number of rows to 10. Hence it starts with 2019 then directly jumps to 2023, but when we see the table we can see information for 2020 to 2022. Is there any way to increase number or rows to view the missing information on the pivot table? Screenshot attached for both pivot and table.

Thanks,

Arnab

John Hung-Oracle

Hi Arnab, I'm closing this post as I see you got a response to the same post in the Reporting and Analytics for HCM forum. Thank you.

https://community.oracle.com/customerconnect/discussion/791979/otbi-pivot-table-limits-numbers-of-rows