Data Visualization return row limit (caching) in table view
SummaryData source is EBS compound query, table view result does not return entire dataset. Requires user input to page through the resulting table view. User does not want that behavior.
The scenario is this:
- View format is Table
- The catch is that the data source is an SQL Statement that directly hits EBS and likely several table joins. I’m guessing that DV has some database paging feature, so the user does not have to wait for the entire query to complete in order to view the results, kind of like most SQL editors. If this is true, is there a way to turn it off? The customer wants only a complete return of the dataset and does not want to continue to paginate.