Business Analytics

Expand all | Collapse all

Data module joins

  • 1.  Data module joins

    Posted Fri July 24, 2020 10:51 AM

    I am creating a report in 11.1.4 from a data module I created and am having trouble with the joins when running the report. When I created the data module in Analytics, I specified the join conditions for the tables I used, but when I run the report it is pulling back all the data from the three tables in my module. I am not seeing a way to specify joins in the report.

    What am I missing on creating the report joins? 



    ------------------------------
    Dave Chirayath
    ------------------------------


  • 2.  RE: Data module joins

    Posted Thu August 20, 2020 06:07 AM

    Hi Dave

    Joins should only be defined in the Data Module and if you are joining like 3 tables from the same data source, it will also send 1 sql statement back to the data source, with the joins in... So you should check the sql statement in the report to verify it's joining inside the statement and not extracting 3 selects and then join them...
    If it's 3 different data sources you are joining, it needs to extract all 3 and join them at the Cognos server.

    Torben



    ------------------------------
    Torben Noer
    Offering Manager, Cognos Analytics and Planning Analytics
    IBM
    ------------------------------



  • 3.  RE: Data module joins

    Posted Thu August 20, 2020 07:15 AM
    Thanks Torben!

    ------------------------------
    Dave Chirayath
    ------------------------------