Report Data Refresh

[KVBR]

Hi, Here is the issue,
I am using cognos 8.1.2 Report studio / oracle 10g. Whenever the data is updated or deleted in the database it is not reflecting into reports immediatly. It is taking some time.

Could some one help me on this.

Thanks,
KVBR.

[sir_jeroen]

are you reporting on cubes? Is Oracle caching data on the RDBMS? If you run a query in oracle, next update the data and rerun the exact query again does it happen also?

[prikala]

One possible reason: Cognos might be caching the query (FM/Governors, "Allow usage of local cache").

[sir_jeroen]

Yep... that's the other option... but if I'm correct caching is limited to the current session.. Unless he never logs out it shouldn't happen...

[KVBR]

Thanks, that is the problem.
It is refreshing now. Thanks a lot.

[sir_jeroen]

Can you tell me what the problem was? Was it that the user never logged out?

[cognos4u]

Hi,

Shal i know the solution for this,i am facing similar issue in my report

Thanks in advance.

Regard's,
Venu