Report Edit error message

[Shadi]

Hi community,

does anyone know why I get this error message when editing one of our reports? how can I fix it?

thanks

[Andras]

Hi @Shadi 

Cross Join error means you are adding data from a folder that is not allowed to be added with other fields directly in one query or the field should be added in the initial query if there are multiple queries involved in the report. This can be resolved by using the Join Query functionality.

Please let me know about the results.

[Shadi]

Thanks Andras, could you please let me know where I can find some information about using the "join Query" function?

[Andras]

Hi @Shadi this recorded video is about creating a custom report that uses a join.  Around minute 33 goes into the details of creating a join: https://assets.concur.com/concurtraining/cte/en-us/cta_cognos_11_report_session.mp4

You can also find more information from the manual: https://assets.concur.com/concurtraining/cte/en-us/cognos_11_business_intelligence_training_manual.d...