Cross Joins Error in Cognos Reporting

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 ‘*’.”

Cross Joins Error in Cognos Reporting

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.

Easy Solution:

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…

Cross Joins Error in Cognos Reporting

It’s as easy as that! This solution has worked wonderfully for me. So the next time you get the dreaded error message about cross joins, remember this simple trick to help get the data you want on the report.

Leave a Reply

Your email address will not be published. Required fields are marked *

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>