Cross Join Error

[midhl]

Hi,

When a report which is working fine in 8.2 is opened in 8.4 the following error is seen
QE-DEF-0459 CCLException
RQP-DEF-0103 Cross joins between query subjects: Query2,X, Y are not permitted for the user who has the identity '{Reportnet Support, HR Gen, HR MRR, HR History, Census, Census COE, Census Reconciliation, Global Distribution Basic, All Authenticated Users, Everyone, COMP_HRG, Consumers, Analysis Users, PowerPlay Users, Readers, Express Authors, Adaptive Analytics Users, System Administrators}'.

Could someone please help me with this.

Thanks,
Murali.

[blom0344]

1. Are you using standalone tables in your model?
2. Did you check that both report definitions (8.2 / 8.4) are absolutely identical?
3. Is the original report set to use cross-joins? 

[CognosPaul]

Are you referencing another query in Query2? Do you have a filter similar to: [Database].[Field]=[Query1].[Field]

[midhl]

Hi,

Since i dont have access to the model ,no idea if at all any standalone tables used.

Both the report definitions are identical and there are no cross joins used in the original report.

Also there is another query called query2 along with a filter [Query1].[Field]=[Query2].[Field] in the report

Annyway thanks for your replies .

[CognosPaul]

Try changing [Query1].[Field]=[Query2].[Field] to [Query1].[Field] in [Query2].[Field].