nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Display more than 200 rows in OTBI while running an adhoc query

Dimansu

We run an adhoc query in Oracle cloud ERP by using OTBI(Navigation: Reports and Analytics -> Browse Catalog -> Create New DataModel -> SQL Query). The limitation of this approach is that it can only retrieve 200 rows (unless you can complete the steps to create the report and export it to excel). If we can get to see more number of records and also export them from the UI without having to complete the rest of the steps of creating a report, it will save us time

Find more posts tagged with

Submitted

Status: Submitted

Comments

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/24125/display-more-than-200-rows-in-otbi-while-running-an-adhoc-query

There is already an idea submitted for same. Please review the existing and upvote there and close this idea.

Increase the count of maximum rows from data model query — Cloud Customer Connect

Thanks.