COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Avisto.sbu on 19 Mar 2014 08:46:45 AM

Title: delete cache
Post by: Avisto.sbu on 19 Mar 2014 08:46:45 AM
Hi,

I don't find how to delete cache data in report studio,
I emptied my db, and published a new package but old data still appears in the report

how to delete it, and make cognos compute the data each time the report is executed?

my problem is mainly on a repeater table, when I create it old data reappears, when I change the query by adding a field right data is displayed.
As soon as I remove the field, old data appears in the repeater table.

This occurs also if I create a new report with the same field in a repeater table, old data appears.

thanks for your answers
Title: Re: delete cache
Post by: Avisto.sbu on 20 Mar 2014 05:16:04 AM
problem resolved with this link

http://pic.dhe.ibm.com/infocenter/cbi/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.ug_cra.10.1.0.doc%2Fug_cra_id10030EnableSessionCaching.html
Title: Re: delete cache
Post by: Francis aka khayman on 20 Mar 2014 08:33:48 PM
or you can set your Query property to Use Local Cache = No
Title: Re: delete cache
Post by: apolodor on 03 Jun 2014 02:26:39 AM
I have a similar issue. I disabled use cache within the package and at the query level (in the report) as well but still brings old data.

I don't want to set it at server level because it might impact other packages.

Normally, making the change at query level (within report) should be enough. Am I missing something here?

Thanks