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

Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!

Data Visualization return row limit (caching) in table view

Received Response
13
Views
1
Comments
edited Oct 15, 2019 12:42AM in Oracle Analytics 1 comment

Summary

Data 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.

Content

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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