Cross Join error report migrated from CRN to C8

[Mpotla]

Hi Friends,

We have a report created in CRN, has a tabular model gives maximum of the date value which is passed from the cube to the drill report,and using this value in the reporting query to filter the data. When we validate the report in CRN, got some Cross Join error, which was fixed by 'Allow Cross Join  'property for the report query.

Now we have migrated the report to Cognos 8 , which is giving the same error, which we were getting in CRN even after 'Allow' Cross join. when i validate the report.

'QE-DEF-0469 QE Message
RQP-DEF-0104 Warning: There is a cross join for the user who has the identity '{All Authenticated Users, Everyone,  Authors, Query Users, Consumers, Event Users, Metrics Authors, Metrics Users, Planning Contributor Users, Controller Users, Analysis Users, Data Manager Authors, Readers, Express Authors, ABC_CRN, ReportNet, report_CRN, Audit, PublicA, C8_MS, C8_ES,  QSC_CRN, C8_AS}'.

Need your help in resoving  issue.

Thanks in Advance

Mohan

[cognosun]

Hi Mohan,

We are facing same issue with a report, after upgrading from 8.1 to 8.4,
getting that cross join error in 8.4, which you got.

This report is working fine in 8.1

[blom0344]

AFAIK Cognos has played with the diverse Governor settings between versions. You can check these in FM under 'edit governors'. Perhaps these setting differ between 8.1/ ReportNet and version 8.4 ?