Oracle Analytics Cloud and Server

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

Report exported to excel takes long time to render and download file

Received Response
984
Views
12
Comments
2»

Answers

  • Venkat Thota - BIP
    Venkat Thota - BIP Rank 7 - Analytics Coach

    Edit this problematic report --> Click on Properties tab ( on right hand side upper corner) --> Go to Formatting tab

    a) FO Processing

    Provide full screenshots showing setting up of properties of "FO Processing"

    b) EXCEL 2007 Output

    Provide full screenshots showing setting up of properties of "EXCEL 2007 Output

    ---------please share the diagnostic file mentioned in above email. Thanks

  • Venkat Thota - BIP
    Venkat Thota - BIP Rank 7 - Analytics Coach

    Does report has any parameters , if yes then run report with limited number of parameter values and monitor the processing time ,

    Also you mentioned that you have scheduled the report , your environment is 12c , so get the diagnostic file , to get this file ,schedule the report again and you will find diagnostic tab ,where enable Enable Consolidated Job Diagnostic ,after report execution completes ,get the file and upload. Thanks