Hello,
I am using cube as my data source for a report. My fact table for the cube is a MQT(Materialized Query Table). I have published the cube and report is showing the data present in the tables at the time of publishing. But, when there is an update on the table, it is not reflecting in the report. Report is still showing the old data.
I have set the 'Use Local Cache' option to No. Still i am not able to get the latest data.
Please suggest.
Thanks for your time.
If it is a Transformer-based cubes, you have to rebuild it to pick up the latest data. Most people schedule this to happen on a nightly, weekly, or monthly basis, depending on how often the underlying data changes and user need to see the changes.
Hi,
I am using cognos dynamic cube.
Thank you
Documentation on dynamic cubes talks about managing the in-memory caches. Basically, dynamic cubes read in most of the data at startup, and agressively cache after that for performance reasons. The short answer to your problem is that you have to tell Cognos when you want to refresh the caches to pick up new data, or stop/restart the cube. This can be scheduled. See http://www.redbooks.ibm.com/redbooks/pdfs/sg248064.pdf (http://www.redbooks.ibm.com/redbooks/pdfs/sg248064.pdf) especially chapter 2.