Should a query result in local query compensation/decomposition (meaning the whole query does not push to the database), then you may see files under the <cognos>\temp\xqe etc folders.
The reasons can vary ranging from:
- something cannot be pushed to a vendor due to them not supporting an equivalent concept
- you are doing a multi-data source join/set operation
- the data in the set/joins including many rows and projected columns.
Similar motivating reasons could exist for CQM.
If you need more information, I recommend you open a support ticket and as applicable perhaps a specific use case.
------------------------------
NIGEL CAMPBELL
------------------------------
Original Message:
Sent: Tue October 24, 2023 10:39 AM
From: brenda grossnickle
Subject: Where does Cognos cache data during a JOIN?
Doing a bit of googling on UDA. Seems like those files are created using Compatibility Query Mode (CQM). We use Dynamic Query Mode (DQM) for all of our reports. Do you think DQM still creates temporary files during a JOIN operation?
------------------------------
brenda grossnickle
BI Programmer Analyst
FIS
Original Message:
Sent: Tue October 24, 2023 02:06 AM
From: Ralf Roeber
Subject: Where does Cognos cache data during a JOIN?
Hello Brenda,
have a look at UDA files in temp folder growing to GB size.
regards,
Ralf
------------------------------
Ralf Roeber
https://linkedin.com/in/ralf-roeber/
Original Message:
Sent: Mon October 23, 2023 12:19 PM
From: brenda grossnickle
Subject: Where does Cognos cache data during a JOIN?
Years ago, I remember monitoring a long running report that had multiple SQL queries and multiple Cognos JOINs by watching the queries execute in MS SQL and then watching the Cognos cache folder grow during the JOINs. Now I have another instance where i have to monitor SQL and Cognos and cannot remember how to find the Cognos cache folder location.
------------------------------
brenda grossnickle
BI Programmer Analyst
FIS
------------------------------