How can I make a Join between 2 tables ?

[nicer]

I know that it's a general question, but I think that I need to make a Join between 2 tables
Engagement and Fix fees
When I'm adding fields from the  Fix Fee table some of the data of the engagement is missing from the report
can you please assist me ?

Sorry for the bad verbalization, I'm new with Cognos and SQL

[MFGF]

I know that it's a general question, but I think that I need to make a Join between 2 tables
Engagement and Fix fees
When I'm adding fields from the  Fix Fee table some of the data of the engagement is missing from the report
can you please assist me ?

Sorry for the bad verbalization, I'm new with Cognos and SQL

Hi,

Joins are generally defined in the package you are using. If you can create a report that contains items from Engagement and Fix Fees already, that means there must already be a join defined in the package, or ekse you would get an error (cross products not allowed) when trying to add items from the two tables.

What do you mean by "some of the data of the engagement is missing"? Can you be more specific? Is it possible you are only seeing rows from Engagement that correspond to rows from Fix Fees? If so, this probably means the existing join is defined as Required (ie an inner join). If this is the case, all you need to do is to change the relationship cardinality in Framework Manager to Optional on the Engagement side (ie an Outer join) and republish your package.

Cheers!

MF.