Cognos Analytics

Hi
We are migrating our databases from Netezza to Azure SQL databases. Certain reports now behave differently in joining queries. In one particular case, we are joining on blood group and the join works for negative blood groups (A-, B-, O-, AB-) but not for positive blood groups (A+, B+, O+, AB+). Does anyone know if the plus-sign could behave differently in Cognos when sourcing from these databases? Of course we can implement a work around but to avoid this in future developments, we want to know the cause.
Thanks

------------------------------
Ester D'Hoe
------------------------------

#CognosAnalyticswithWatson

Hi Ester,

I believe you need to create a blood group key such as :
Blood_KeyBlood_Group

1	A-
2	B-
3	O-
4	AB-
5	A+
6	B+
7	O+
8	AB+

Then you would create the join with Blood_Key instead of Blood_Group.

Best regards,


------------------------------
Patrick Neveu
Positive Thinking Company
------------------------------

Original Message:
Sent: Thu November 17, 2022 05:49 AM
From: Ester D'Hoe
Subject: Joins with data from Azure SQL database not always working

Hi
We are migrating our databases from Netezza to Azure SQL databases. Certain reports now behave differently in joining queries. In one particular case, we are joining on blood group and the join works for negative blood groups (A-, B-, O-, AB-) but not for positive blood groups (A+, B+, O+, AB+). Does anyone know if the plus-sign could behave differently in Cognos when sourcing from these databases? Of course we can implement a work around but to avoid this in future developments, we want to know the cause.
Thanks

------------------------------
Ester D'Hoe
------------------------------

#CognosAnalyticswithWatson

Hi Patrick

Thank you for the fast reply! Yes, this is the work around we implemented, but do you happen to know why the original join worked with Netezza databases but not anymore with Azure SQL databases?

Many thanks, Ester

------------------------------
Ester D'Hoe
------------------------------

Original Message:
Sent: Fri November 18, 2022 04:21 AM
From: Patrick Neveu
Subject: Joins with data from Azure SQL database not always working

Hi Ester,

I believe you need to create a blood group key such as :
Blood_KeyBlood_Group

1	A-
2	B-
3	O-
4	AB-
5	A+
6	B+
7	O+
8	AB+

Then you would create the join with Blood_Key instead of Blood_Group.

Best regards,


------------------------------
Patrick Neveu
Positive Thinking Company

Original Message:
Sent: Thu November 17, 2022 05:49 AM
From: Ester D'Hoe
Subject: Joins with data from Azure SQL database not always working

Hi
We are migrating our databases from Netezza to Azure SQL databases. Certain reports now behave differently in joining queries. In one particular case, we are joining on blood group and the join works for negative blood groups (A-, B-, O-, AB-) but not for positive blood groups (A+, B+, O+, AB+). Does anyone know if the plus-sign could behave differently in Cognos when sourcing from these databases? Of course we can implement a work around but to avoid this in future developments, we want to know the cause.
Thanks

------------------------------
Ester D'Hoe
------------------------------

#CognosAnalyticswithWatson

Hi Ester,

If you take a copy of the SQL out of Cognos and put it in a SQL tool, does it do the same thing? Cognos wouldn't know what the row data is before it sends off the query to Azure, it wouldn't modify it based on there being - or + in the rows.

My suspicion is that the dataset returned to Cognos is where the issue resides.

------------------------------
TREVOR COMEAU
------------------------------

Original Message:
Sent: Fri November 18, 2022 04:31 AM
From: Ester D'Hoe
Subject: Joins with data from Azure SQL database not always working

Hi Patrick

Thank you for the fast reply! Yes, this is the work around we implemented, but do you happen to know why the original join worked with Netezza databases but not anymore with Azure SQL databases?

Many thanks, Ester

------------------------------
Ester D'Hoe

Original Message:
Sent: Fri November 18, 2022 04:21 AM
From: Patrick Neveu
Subject: Joins with data from Azure SQL database not always working

Hi Ester,

I believe you need to create a blood group key such as :
Blood_KeyBlood_Group

1	A-
2	B-
3	O-
4	AB-
5	A+
6	B+
7	O+
8	AB+

Then you would create the join with Blood_Key instead of Blood_Group.

Best regards,


------------------------------
Patrick Neveu
Positive Thinking Company

Original Message:
Sent: Thu November 17, 2022 05:49 AM
From: Ester D'Hoe
Subject: Joins with data from Azure SQL database not always working

Hi
We are migrating our databases from Netezza to Azure SQL databases. Certain reports now behave differently in joining queries. In one particular case, we are joining on blood group and the join works for negative blood groups (A-, B-, O-, AB-) but not for positive blood groups (A+, B+, O+, AB+). Does anyone know if the plus-sign could behave differently in Cognos when sourcing from these databases? Of course we can implement a work around but to avoid this in future developments, we want to know the cause.
Thanks

------------------------------
Ester D'Hoe
------------------------------

#CognosAnalyticswithWatson