cancel
Showing results for 
Search instead for 
Did you mean: 
Shadi
Occasional Member - Level 1

Report Edit error message

Shadi_0-1718321209638.png

Hi community,

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

thanks

3 REPLIES 3
Andras
SAP Concur Employee
SAP Concur Employee

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.

 


Best wishes,

Andras
SAP Concur

Did this response answer your question? Be sure to select “Accept as Solution” so your fellow community members can be helped by it as well.

Shadi
Occasional Member - Level 1

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

Andras
SAP Concur Employee
SAP Concur Employee

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...


Best wishes,

Andras
SAP Concur

Did this response answer your question? Be sure to select “Accept as Solution” so your fellow community members can be helped by it as well.