Oracle Fusion Data Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion Data Intelligence

Categories

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

Tips for Improving Load Time of Detail Report

Accepted answer
24
Views
1
Comments
Mike Wulf
Mike Wulf Rank 2 - Community Beginner
in Oracle Fusion Data Intelligence

Using HCM Workforce Core, I created a dataset to capture hire details from 2023. I set the data access to Automatic Caching, created a daily reload schedule and created an index to run upon refresh.

I then created a workbook from this dataset which returns ~70k rows and has 35 columns. The issue I'm running into is the initial load time, as well as the load time when applying a filter (Business Unit in my case) is taking upwards of 5 mins.

Any tips for how to improve the load times are greatly appreciated and thanks in advance.

Best Answer

  • JohnW-Oracle
    JohnW-Oracle Rank 7 - Analytics Coach
    Answer ✓

    Hi @User_LW96B

    You are doing all the right things. We have a couple KM Article with additional suggestions:

    FAW:FDI:FDIP: Troubleshooting and Optimizing Custom Report/DV Performance (Doc ID 3015469.1)

    and

    FAW : Performance issue in "HCM - Workforce Core" Analysis And Dashboards (Doc ID 3004156.1)

    The key points are:

    Disable Brushing if its not being used.

    and

    Add dashboard filters instead of workbook or canvas filters and if you are using them as prompts, add a default value.

    Regards,

    John