Cognos Analytics

 View Only

  • 1.  Where does Cognos cache data during a JOIN?

    Posted Mon October 23, 2023 12:19 PM
    Reply

    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
    ------------------------------


  • 2.  RE: Where does Cognos cache data during a JOIN?

    Posted Tue October 24, 2023 02:07 AM
    Reply

    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


  • 3.  RE: Where does Cognos cache data during a JOIN?

    Posted Tue October 24, 2023 10:34 AM
    Reply

    Where is the location of this "temp" folder. I see a temp folder under the Cognos root. But there are many subfolders. Trying to find where specifically the path and name of the folder that is used during a Cognos Report JOIN operation. 



    ------------------------------
    brenda grossnickle
    BI Programmer Analyst
    FIS
    ------------------------------

    Original Message


  • 4.  RE: Where does Cognos cache data during a JOIN?

    Posted Tue October 24, 2023 10:39 AM
    Reply

    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


  • 5.  RE: Where does Cognos cache data during a JOIN?

    Posted Mon October 30, 2023 12:01 PM
    Reply

    Hi Brenda,

    UDA files are for the CQM
    For DQM the location of temporary files used for data processing is <install>/temp/xqe the files have names like:
    xqe_ScrollableTabularCache_1698681505294_12.cache
    These files are created when Cognos does local processing, including function calls that could not be sent to a database and joins/unions across different database providers.

    I hope this helps



    ------------------------------
    Kind regards,
    Henk Cazemier
    ------------------------------

    Original Message


  • 6.  RE: Where does Cognos cache data during a JOIN?

    Posted Mon October 30, 2023 09:15 PM
    Reply

    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


Related Content