Oracle Transactional Business Intelligence Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OTBI embedded with Sales Cloud - Export table with more than 500.000 cells

11
Views
2
Comments

Organization Name

TRENITALIA S.p.A.

Description

Hi!

this problem is found on the Oracle Engagement Cloud BI. The customer is complaining about the tiny error message at the bottom of the worksheet when he tries to export a table with more than 500.000 cells.
He's asking to be alerted when the limit is exceeded by changing the message appears inside the popup (attached file) into "Export completed with fewer lines. You exceeded the maximum limit of 500.000 cells."
Is it possible?

Thanks

Francesco

Use Case and Business Need

the number of matched incorrectly extracted records and an inconspicuous warning of a partial export could create business problems

More details

the partial extraction message is present only inside the export file at the last line and in a central position. So as in our case where we need to export 80 columns the message appears between row 36 and 44. unacceptable for the customer.

Original Idea Number: 3c18e4f66e

popupExport.PNG

1
1 votes

Submitted · Last Updated

Comments

  • AntonioLConte-Oracle
    AntonioLConte-Oracle Rank 1 - Community Starter

    Definitively this limitation is painful. Would you provide a solution for this.

  • Renjith Raj
    Renjith Raj Rank 1 - Community Starter

    The suggestion Oracle provides is to use BI publisher but not every user knows how to create a BI publisher as it is not as easy as creating OTBI reports. Also customization of the BI publisher report is difficult. It would be great if Oracle could look into extending the limit.