Make sure that the SQL in the same in both of your queries. If it is then the difference is down to the data
------------------------------
Chris Turner
------------------------------
Original Message:
Sent: Tue March 07, 2023 01:00 AM
From: Aida Lobo
Subject: Mismatched between Cognos and OMS
Hi Team,
I have created Order in Pipeline (OIP) report to show the number of orderliness for each unit in INDIA. However, we have found data mismatch between the OMS (source) and Cognos (OIP).
Is there a way to reconcile the two to make it aqual.
Thanks
Aia
Sent from Mail for Windows