Are you experiencing a Cross Joins Error in Cognos Reporting?
If you have ever spent some time working with Cognos reports you more than likely had the error “Cross joins (between query subjects: SQL1…blah, blah….) are not permitted for the user who has the identity ‘*’.”
Why it happens:
This error occurs because there is no relationship between the tables at the model level in Cognos. It can be very frustrating when building reports. Before I learned this trick, the only way to get around it was to try and take a different approach to get the same results using different tables. The information required for the report may not always be available on different tables, so this is where the trick really comes in handy.
Open Cognos Report Studio and navigate to the query you are getting this error from and look under the Query Properties (left side, down low on screen). You will see the Property named ‘Cross Product Allowed’. Select the dropdown and choose ‘Allow’. Run the report to test it and Save the report. See screenshot below…