Ability to default Data Model number of "Rows" and view mode to "Table View"

Jeramie Ryan

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

UCLA

Description (Required):

It's extremely time-consuming to have to repetitively change both of these while working on a SQL data model. 

Use Case and Business Need (Required):

Verifying Data Model data for any report

Enhancement Request / Service Request:

From a usability perspective a change should be considered. When working with Oracle Cloud SaaS products that leverage BIP for reporting it is not possible to connect directly to the database and author/test SQLs outside of the BIP Data Model. That said, complex SQL Reports generally require breaking queries down into smaller chunks that can be manually validated using the Data Model Data tab. Note: I am working with the Student Financial Planning (Vocado) SaaS application. During this process I regularly find myself going back and forth between defining the SQL and rerunning the Data Model SQL to see the results. Each time I'm forced to modify the row count and view mode, which is extremely cumbersome. I think either being able to change these defaults or open up a better full window SQL editor (with more helpful error messages) would be extremely helpful and save a lot of time and clicks.