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

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
------------------------------

What query subjects to each of these fields come from?
Where did you create the relationships (FM, DM, directly in the report)?
Can you add a picture of that

------------------------------
NORBERT Bracke
IBM
------------------------------

Gopi,

I get this when I'm joining two tables by a single field and one of the tables has a null values in the join field.  If you filter out the null values in one of your tables, the query should run.  

Jeanie

------------------------------
Jeanie Krieger
Business Analyst
California State University, Sacramento
Sacramento CA
------------------------------