Data change isn't reflected correctly in report?

[Newb]

Hi all,

I'm using 11.2.1 here. And source of report used is from client data source > dataset > data module. After we refresh the data set, we can see the data reflects correctly in data module. But whenever we rerun the report, or refresh the report (while report is opened) using report refresh button, it sometimes doesn't show the data changes instantly.

We went on to test using excel upload data to reproduce this. It didn't surprise us that it is also happening.

If you may test this:
1) Create a simple excel/csv file
2) Upload it into Cognos Analytics
3) Create a data module
4) Use the data module in a report and save the report
5) Go into the data module, edit the expression of one of the measure column (i.e., original_value +100000000000000000)
6) Save the data module
7) Refresh the report and see if the +1000000000000000 was reflected
8. Repeat step 5-7, check if you can see the inconsistency of data refresh in report.

The expectation is the change should reflect instantly in the report, but it did not. Or maybe my expectation is wrong?

Thank you.

[MFGF]

Hi all,

I'm using 11.2.1 here. And source of report used is from client data source > dataset > data module. After we refresh the data set, we can see the data reflects correctly in data module. But whenever we rerun the report, or refresh the report (while report is opened) using report refresh button, it sometimes doesn't show the data changes instantly.

We went on to test using excel upload data to reproduce this. It didn't surprise us that it is also happening.

If you may test this:
1) Create a simple excel/csv file
2) Upload it into Cognos Analytics
3) Create a data module
4) Use the data module in a report and save the report
5) Go into the data module, edit the expression of one of the measure column (i.e., original_value +100000000000000000)
6) Save the data module
7) Refresh the report and see if the +1000000000000000 was reflected
8. Repeat step 5-7, check if you can see the inconsistency of data refresh in report.

The expectation is the change should reflect instantly in the report, but it did not. Or maybe my expectation is wrong?

Thank you.

Hi,

If you edit the report, navigate to the Queries pane, and select the query your report is using, what is the "Use local cache" property of the query set to? If it's "Default" or "Yes", try setting it to "No" and saving the report.

Cheers!

MF.

[Newb]

Hi MF,

That 'use local cache' setting is applicable for data which is sourced from DB only. For Dataset>data module, apparently it is not.
Did you try the steps? 

Thank you.