Hey all, I have a report that has one prompt and when I select a value from the prompt I am getting different value in COG 10 and COG 11.
Some details
1)Report has one query which is SQL
2)Has one parameter that is in the SQL as a macro
3)We have migrated from CQM to DQM
Any advice how to fix this ?
My understanding is that DQM parses and interprets both SQL statement and macros differently from CQM. When I say differently, that is DQM is much more syntax sensitive than CQM.
In CQM you can get away with sloppy SQL syntax and be forgiven; DQM is a much harsher mistress/master.
Review you SQL syntax and macro usage. The problem may be as simple as a misused semi-colon or as complex as sub-query usage.