Hi Gopi,
This is the kind of error that can be a bit frustrating.
One approach is to narrow it down by adding the 3 new fields one at a time.
This will at least identify the one new field when the issue starts to occur.
Which query subject does that field come from? It is probably not from one of the query subjects already in this query.
If you have access to FM, it may be easier to track down how the queries are related to one another.
Please post how things are going.
// Henk
------------------------------
HENK CAZEMIER
------------------------------
Original Message:
Sent: Thu April 16, 2020 07:18 AM
From: gopinath murthy
Subject: cross join issue in cognos analytics 11
Hi,
In my report even though we have join between 2 query subjects, when I try to add other 3 new fields to the report.
I am getting below error, please help me to solve the issue.
Thanks
Gopi
------------------------------
gopinath murthy
------------------------------
#CognosAnalyticswithWatson