Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

Automate 'Reload Data' from DV dataset.

Received Response
18
Views
2
Comments
Tony_OAS_Apex_User
Tony_OAS_Apex_User Rank 5 - Community Champion
in Oracle Analytics Forum

How can I configure my Oracle APEX application to automatically refresh the data from an Oracle DB data set after an edit, so that the user sees the change in real-time without needing to click "Reload Data"?

It's feed off from OAS analysis but the data source is coming from Dataset which not in the RPD.

image.png

Answers

  • Tony_OAS_Apex_User
    Tony_OAS_Apex_User Rank 5 - Community Champion

    I am following this documents for Live update on data set.

    https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/specify-whether-dataset-table-is-cached-or-live.html#GUID-440BD3EC-9241-48EF-9AB0-391F134C646E

    will report back if it works.

  • Tony_OAS_Apex_User
    Tony_OAS_Apex_User Rank 5 - Community Champion

    We had to put the BI Publisher caches to 0 and make the data model Live. and it worked.

    Thanks!