Oracle Communities

Oracle Analytics and AI

Child Item

Oracle BIP DataModel -> Default views 'Table View' and '200' rows - Possible

Description

Hello,

Just wondering if there are any default settings available to achieve 'Table View' and '200' rows. Attached a picture. If not, I guess its high-time to consider these small settings in next releases. You can find more information at this post https://cloudcustomerconnect.oracle.com/posts/509953cb2a.

Thanks,

Santosh

Use Case and Business Need

Would be useful to select a default option to table view and change from default 5 rows to more. Without this, every time we need to change from tree view to table view and it takes a while to load. I am sure this will save few minutes here and there.

More details

See attached picture.

Original Idea Number: 36db755ba1

Find more posts tagged with

Declined

Status: Declined

Comments

AllwinJayapal

This is a must have. Good suggestion. Have been a pain every time we use BIP.

Sourabh sp

Much needed.

SantoshKumarBhairi

Oracle Prod Dev Team,

Just wondering if there are any timelines and I am happy to provide you any additional information.

thanks,

Santosh

Alan Lee - Oracle-Oracle

We will review the enhancement request. There is no commitment or timeline at this time.

SantoshKumarBhairi

Thank you for the interim update.

Alan Lee - Oracle-Oracle

After further review, there is no plan to update row limits for data model preview. The current limit provides a safeguard against potential stability and performance issues as queries are made synchronously for preview.

SantoshKumarBhairi

@Alan Lee - Oracle-Oracle - Thanks for the update and sorry for delayed response on it.

a) I am not sure about the stability issues here just to get a 200-rows set from the datamodel whereas a large amount of rows can be extracted through report. Considering there is no direct connecton to Fusion DBs (like SQL-Developer), it helps massively. Anywyas, can the limit be increased little more than 5 rows? Maybe 10 at-least?

b) How about changing the defaul option of 'treeview' to 'table'? Does it have any stability issues? If so, I would like to understand/learn more about it.

I am sure Oracle would have gone through the comments from Oracle community users about its desirability and how this little trick helps in saving good amount of time during the devevelopment process.

Happy to share any additional information.

thanks,

Santosh

MandeepGupta

Alan Lee - Oracle-Oracle,

Can you please consider atleast defaulting the view option to table?

Thanks.

SantoshKumarBhairi

Hi @Alan Lee - Oracle-Oracle,

Sorry I never got an opportunity to look at this post earlier. I would not necessarily agree about limiting rows of 200 but can we have an option on the View. Mostly (or everyone) will use 'Table View' so request you to consider at-least this option in the future releases.

Alan Lee - Oracle-Oracle

@Sandeep S. Chauhan-Oracle Can you please review option to default to "Table View"