Oracle Analytics Cloud and Server Idea Lab

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

When exporting to Excel, data may be missing or cell merges may be broken every 300 rows.

Needs Votes
247
Views
1
Comments

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

アイエイエフコンサルティング株式会社

Description (Required):

- Doc ID 2322470.1 OBIEE 12c - Export To Excel Is Missing Data

Since the OAC cannot handle the situation described above, 

we would like to be able to change the parameter (RowsInWindowedMode) from the system setup ,

so that we can fix the problem caused by reading data in every 300 rows.


When exporting a formatted Excel file with " suppressed values", the following problem occurs.

The following problems are occurring.

(1) When merging cells that include rows that are multiples of 300, the cells are not merged.

(2) Some data is missing from cells that contain rows that are multiples of 300.


Use Case and Business Need (Required):

(1) When attempting to analyze using Excel, cells that should be merged are not merged, which may induce errors in the analysis.

(2) When trying to analyze using Excel, the missing data cannot be referenced and the values are different from the entity.

As a result, correct analysis cannot be performed, and this is interfering with business operations.


Enhancement Request / Service Request:

4
4 votes

Needs Votes · Last Updated

Comments

  • Aiswarya G
    Aiswarya G Rank 4 - Community Specialist

    RowsInWindowedMode should be provided inline with DefaultRowsDisplayedInDownload. Hence exposing one parameter may not work. Also, both parameters should have range based on the OCPU capacity to avoid over consumption resources or crashes.