getting cross join error

[karthik12345]

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

[R Ambre]

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.

[priya@90]

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.