where will be Data Store in Cognos

[jaganlalrm]

hi

i want to know while running report. data for a report it will taken from database everytime or it will be stored in the content manager.

if it data stores in content manager when it will be updated.

Thanks in Advance

[MFGF]

Hi,

When you are running a report, the data is retrieved from the underlying data source. Some in-memory caching does occur, but the data is not stored by Content Manager in the Content Store database. If you choose to run a report and save the rendered report output (eg as PDF), this saved output does get stored in the Content Store database (by default) but your Cognos instance can also be configured to store these on a filesystem too, if desired.

Cheers!

MF.

[jaganlalrm]

hi

then ever time when i run report it will retrieve data from data base.

I will how i have create report

1) First in Frame work i include database and
2) Write Query an take required data item and
3)create packages an publish in Cognos Bi Connection
4)Using that i created Report.

Now tell While Running Report ever time data will taken from database or it will stored in any local cache.

Thanks in Advance   

[MFGF]

The amount of caching being done depends on whether you are using Dynamic Query Mode or not. If you are, then the data is read from the data source and stored in cache the first time it is required. This cache is used across multiple users and multiple login sessions, and there are controls for how and when it is refreshed. If you are not using DQM, some caching of data is done, but it is local to each user and each login session, so is far more transient.

Cheers!

MF.

[jaganlalrm]

Am not using Dynamic query mode.

And am not using local cache also. then it will every time get result set from data source 

[MFGF]

Yes

[jaganlalrm]

If i use cube. Data will Store in Cube or it also get data from data base only every time.

[MFGF]

Hi,

Cognos BI doesn't "move" data when you write reports against it. If the data is in a cube, that's where it's read from by Cognos, and that's where it will be the next time it needs to be read.

Cheers!

MF.