Hi,

I'm trying to create a data module and the join I'm trying to create is an OR join. Table1.Column1 = Table2.Column1 OR Table1.Column2 = Table2.Column2. When I try to add both joins using the UI, it creates an AND join Table1.Column1 = Table2.Column1 AND Table1.Column2 = Table2.Column2. In Framework manager I can easily update this join using the expression editor, but I'm not able to find the expression editor in data module interface. I'm using Cognos Analytics 11.1.5.

I've attached a screenshot of the relationship editor I see.

Thanks,

------------------------------
Nipun Gupta
------------------------------

#CognosAnalyticswithWatson

Hi CA Community,

Re-visiting this thread. Any insight from anyone?

Thanks,

------------------------------
Nipun Gupta
------------------------------

Hi Nipun,
There is no support for entering the expression of a join relationship. It isn't planned for the near future either.
 Options would be: add a calculation to one or both tables and use that in the join. Sometimes a coalesce can be used, at other times a more elaborate expression might be needed, and then use multiple terms in the join, to get the same effect as a between clause.

If you're able to share some of the values of the tables that you're trying to join, that would be helpful in figuring out what might work.

Another option would be to create a multi table SQL statement on this pair of tables and hand-code the join expression.
// Henk

------------------------------
HENK CAZEMIER
------------------------------

Original Message:
Sent: Wed July 22, 2020 10:11 AM
From: Nipun Gupta
Subject: C11.1.5 Data Module relationship editor missing

Hi CA Community,

Re-visiting this thread. Any insight from anyone?

Thanks,

------------------------------
Nipun Gupta
------------------------------

Hi Henk,

Thank you so much for the information. It's good to know that I'm not going crazy. For some reason I thought the ability to enter custom expressions was available in the earlier versions of DM, but I could be mistaken.

Thanks,

------------------------------
Nipun Gupta
------------------------------

Original Message:
Sent: Wed July 22, 2020 12:54 PM
From: HENK CAZEMIER
Subject: C11.1.5 Data Module relationship editor missing

Hi Nipun,
There is no support for entering the expression of a join relationship. It isn't planned for the near future either.
 Options would be: add a calculation to one or both tables and use that in the join. Sometimes a coalesce can be used, at other times a more elaborate expression might be needed, and then use multiple terms in the join, to get the same effect as a between clause.

If you're able to share some of the values of the tables that you're trying to join, that would be helpful in figuring out what might work.

Another option would be to create a multi table SQL statement on this pair of tables and hand-code the join expression.
// Henk

------------------------------
HENK CAZEMIER
------------------------------


Original Message:
Sent: Wed July 22, 2020 10:11 AM
From: Nipun Gupta
Subject: C11.1.5 Data Module relationship editor missing

Hi CA Community,

Re-visiting this thread. Any insight from anyone?

Thanks,

------------------------------
Nipun Gupta