If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Data in FM's package doesn't refresh after UPDATE

Started by nooboso, 07 Jul 2015 04:07:36 PM

Previous topic - Next topic

nooboso

Hi everyone!
I'm David from Chile and i need your experience. As a business intelligence analyst and i built a couple of package in framework manager that have regular and fact dimentions. The problem is when the data is updated on database (SQLServer 2008 or Oracle 11g), the package doesn't show the changes until 2 hour later or more (sometimes changes in the data is displayed next day). This happens even though we try to update data using the buttons refresh and update of each tool

What could be the possible cause?

Some info:
*All of these packages are built in DQM.
*Cognos BI version is 10.2.1 over Redhat 6.
*This happens with all of web tools (WS, WSA, RS, AS) and with Cognos Analysis for Excel (CAFE)

cognostechie

Hi David -

When Cognos is installed, by default it does caching and reads 5 times from the cache and then refreshes the data from the DB (that 5 times is not strictly maintained so it could be more). I had the same problem earlier and after changing the setting for caching, it started refreshing from the DB every time I clicked on the report. All of the studios (web tools and CAFE) you have mentioned read the data from the package which reads from the cache. That being said, I am not sure about DQM as I am still trying that out.

This is how I did it:

Go to Cognos installation/configuration directory:

1.Copy CQEConfig.xml.sample file to cognos insllation location/bin and rename it CQEConfig.xml.
2.Open the CQEConfig.xml in Notepad.
3.Change the 'queryReuse' parameter  to 0.
4.Re-start Cognos service.

By the way, there are some settings in FM and Report Studio also for caching but I don't think those have anything to do with this.