bobby

• Aug 22nd, 2006

 

You can view the relations between query subjects in object daigram window in FM, if there's a loop between three or more QS then it can cause improper outcomes in report, create a short-cut for QS and rejoin, to avoid ambiguity.

pavanreddycognos

 Profile Answers by pavanreddycognos 

• Nov 2nd, 2006

 

Hi Friends,

Ambiguous Relationships : are defined with multiple query paths which leads to performance degradation and wrong results to be displayed on the report. These are results due to joins which are also called as 'loops'.

We can identify the ambiguous relationships if we validate the joins, after creating the relationships between the query subjects(called joins).

Ambiguous relationships can be resolved my removing the joins and creating the Aliases(Short-cuts).