Active reports in connected mode

[Prem Mehrotra]

I am newbie to Cognos. I have read that active reports can also be run in connected mode, i.e.,
get live data from database when they run.

1. Will performance in connected mode for large amount of data be better than in disconnected mode because now it is doing sql queries on database where it can take advantage
of database indexes etc. In disconnected mode; report specification and all the data is in an
.mht file and browser (or is there any Cognos software) has to go through this data making things slower.

2. I want to use Cognos active report template which has many more controls in connected mode, but not clear whether I will still be working through  one .mht file. IN connected mode, will drill down/drill up as well as drill through work the same way as in a non active report template.
3. Also, in disconnected mode, is there any Cognos client software used when viewing .mht file or
Is only Browser involved?

[MFGF]

Hi,

Running an Active Report in connected mode might be very frustrating for your users. All it means is that the MHT file is generated on-demand, and this may well take a good while to do (Cognos 10 has to extract all the relevant data then render the facets of the mht file before displaying it in the browser). Perceived performance could well be very poor, taking into account the time this might take.

If you use an Active Report template, your report will be rendered as an mht file, and drill down/up etc will not be relevant. Connected mode simply means the mht is rendered on-demand.

In disconnected mode, all you need is a browser capable of rendering the mht file, or you can download the Cognos iPad app from the apple store and consume the mht in that.

Cheers!

MF.

[Prem Mehrotra]

Thanks a lot for clarifying.