Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: karthik12345 on 01 Mar 2016 04:05:15 AM

Title: getting cross join error
Post by: karthik12345 on 01 Mar 2016 04:05:15 AM
Hi,
  I am doing some poc works, so i imported the tables from the data base with relations and i created the package in FM and publish to ibm connection, in report studio i am getting below error while

XQE-PLN-0091

      Cross joins (between query subjects: ADDRESS,ENTRY) are not permitted.
kindly advise me how to resolve the issue.

Thanks.
Karthee




Title: Re: getting cross join error
Post by: R Ambre on 01 Mar 2016 07:14:48 AM
Hi,

Do you have join between  ADDRESS and  ENTRY query subject in your model ?
If not then because of that may be you are getting an error.
Title: Re: getting cross join error
Post by: priya@90 on 04 Mar 2016 12:40:45 PM
Ambre is correct and one more solution in report UI page. You just leave as it is without joins and join from both tables on ID. if ur not sure how to given joins in FM follow in UI page.
Text only | Text with Images