Workbook not refreshing data

Question

Hi,

I have a workbook that currently is not refreshing the data, for example the total quantity on the database (view with dblink) is 3.200 and the total on the workbook is 3.000. I already tried using the Refresh Data button on the workbook with no success. The only way I was able to reload the data was going to Data > DataSets > Inspect > Reload Data > Run Now. Is it possible to have the workbook refresh in real time when you enter the workbook or at least when you click on the Refresh Data button?

The cache is already disable on Advanced System Settings.

Any help is appreciated.

Thanks.

Chere-Oracle · Answer

Have you tried changing the Data Access setting to 'Live'?  (Open the dataset, go to table's tab, and click the Edit Definition button.  The Data Access option is in the right-hand pane.)