sqldatabasecognos

Join in Cognos Data Module returns error message

I want to perform a simple join of two tables. Each Table has only one row. The join column should be "DP". The Value for DP is "India" in both Tables. The Value comes from a calucation (see screenshot). When I perform the join (full outer join, 1 to 1, no filtering) I receive this error message:

XQE-DAT-0001 Data source adapter error message:Detected implicit cartesian product for FULL OUTER join between logical plans Project [India AS DP#384910, Year_#369960, Net_Sales#369961] +- Relation[Year_#369960,Net_Sales#369961] parquet and Relation[Industry#369945,Value_#369946] parquet Join condition is missing or trivial.

Calculation

Column to join

Join Statement

Solution

  • The error message you received indicates that there is an issue with the join condition in your query. You're doing a FULL OUTER JOIN without specificy the column on which to join, which is similar to a full cartesian join (called "CROSS" join).

    To fix this issue, you need to specify a valid join condition that relates the tables based on the "DP" column.