Hi folks, exporting from Query Studio causes the query to re-run. Can this be changed? Seems like it should just export the data already retrieved.
Thanks,
Doug
there some location where you have to do some settings.
First of all, do you allow query reuse? Because that's the main thing. You can set it within FM, in a system file CQEconfig.xml, within ReportStudio.
Hi thanks for the reply. I will look into this.
Hi, checked this out, and we have the "Allow usage of local cache" option checked on the model governors.
Cognos documentation says this as well:
QuoteReusing Cached Data in Query Studio
Query Studio reuses cached data under various conditions. If query reuse is turned on in the model and the action can be satisfied by a subset of the cached data set, the report uses the cached data. For example, changes to the report such as adding a filter or removing a column, may change the report data, but the request can still be satisfied from a subset of the cached data.
If query reuse is turned off and the action can be satisfied from the cached data set without modifications, the report still uses the cached data. For example, changing the report format uses the previous data set even if query reuse is turned off. This is known as cursor reuse. Cursor reuse is used when the cached data can satisfy the request without modifications.
Reports that were created in Query Studio always use the same setting as that specified in the model. If the model has query reuse turned on, the report attempts to use the cached data.
So I'm still stuck, I guess. Maybe the report export feature is unable to rely on the retrieved data in the way that the query studio GUI is, so all of the data has to be re-retieved. Surprised no one else has asked about this. Is there another Cognos forum that might be better than this one?
Thanks,
Doug