Oracle Fusion ERP Analytics

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

Categories

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

Problems in "Reload Data" on a data set

Received Response
21
Views
4
Comments
SERGIO BARRETO
SERGIO BARRETO Rank 5 - Community Champion
in Oracle Fusion ERP Analytics

I created a dataset with a report built from Fusion BI Publisher, however, the report is not updating in real time. When I try to click on "Reload Data" in the dataset the following message appears:
"No Datasets found with Data Access set to Automatic Caching"

How can I solve this? I need the information in FDI to be updated in real time.

image.png
image.png
Tagged:

Answers

  • Ram-Oracle
    Ram-Oracle Rank 6 - Analytics Lead
    edited Jan 30, 2025 4:31PM

    @SERGIO BARRETO could you please clarify if the dataset is created based on adw connection by calling a table that was created using bip dataaugmentation job in fdi?

    edit the dataset and share the settings of data access ,is it set to live ?

    If the dataset is created from data augmented table ,then the table gets populated along with incremental run i.e all dataaugmentation jobs will run along with daily incremental runs.

  • SERGIO BARRETO
    SERGIO BARRETO Rank 5 - Community Champion

    Hi @Ram-Oracle

    Yes, first, create the report in Bi Publisher, then create the dataset through data augmentation, and finally, with a connection to ADW in OAC, use the table to search for the dataset.

    Daily incremental is not clear to me, because I have the pipeline configuration to refresh daily, but even so, the information is not refreshed.

  • SERGIO BARRETO
    SERGIO BARRETO Rank 5 - Community Champion

    Hi @Ram-Oracle How can I run refresh of this dataset from OAC? I keep getting the same error

  • Ashish-Oracle
    Ashish-Oracle Rank 7 - Analytics Coach

    @SERGIO BARRETO In order to refresh/reload the data in the BIP report based Augmentation tables, you will have to go to FDI→Console→BIP Augmentation and then perform the required operation. Post this the data in the OAC datasets will be automatically refreshed.