Hi Experts,
Do we have anything like comparing same queries to know what is missing why data is getting different in both queries.
usually we create Y query in production if user needs the report immediate and later we develope in dev environment and then transport upto production by replacing the Y query with Z query.
Now I did the same and in production my Y & Z queries are getting different results in reports where as they look exactly same in query designer. I didn't see even single difference but data is different on same multiprovider.
Is there any chance to see what is different in both queries other than manual look.
Thanks.