Hello,
We had recently upgraded to Cognos 8.3 from 8.2 version.
One of our end user's report has been throwing some issues since migration. The report has a prompt query which is the culprit. On validation, Cognos throws an error, stating ambigously defined column and hence unable to generate the query.
But, if I bring in the same column again from the Query subject, and validate the report, the report runs fine. None of her other reports, which have similar prompts from the same table have any issues.
I have checked FM 8.2 and FM 8.3 and the query generated is similar. No issues there.
Can some one please advice on this issue?
Looking forward for your thoughts,
Sag