The following Cognos error occurs when two query subjects that do not have any links at the model level are used in the report.

RQP-DEF-0103 

Cross joins (between query subjects: [Request].[...], ..., [WorkflowHistoryDetails].[...]) are not permitted for the user who has the identity '*'

Resolution

Link the two query subjects using Joins. For example, for linking Request and WorkflowHistoryDetails, do the following:

  1. Create a query (Q1) that includes all fields you want to display from Request. Be sure to select the |RequestID.
  2. Create another query (Q2) that includes all fields you want to display from Workflow History Details, including |EntityID.
  3. Create a final query (Q3) with a join that joins Q1 and Q2 on RequestID=EntityID. Ensure that it is a one to many relation.

4. Add all the fields you want to display from Q1 and Q2 into Q3. When you use Q3 in your report, you will see that the relation between the request and the workflow history is established.