Cognos Interview questions


Total available count: 27
Subject - Business Intelligence
Subsubject - Cognos

What is the difference between group and association?

In Cognos 'group' is used to suppress the duplicate values. And 'associate' is used to suppress the values if it is a one-one relationship.

  • Group: It Eliminates the Duplicate values from the report breaks the columns. It's having a one to many relationships.
  • Association: It Eliminates the Duplicate values from the report and it's having a one-one relationship.

Both Group and Association eliminate duplicates in a column. But we cannot use the Association alone. It should have one to one relationship with the grouped column.

Using association is a performance enhancement technique. A group is used to eliminate the duplicates in data, whereas Association is used to hire or suppress the values in 1 to 1 relation.




Next 5 interview question(s)

1
What is the difference between drill down and drill through?
2
How can I convert a list report/Cross tab Report in Cognos EP series into a bar chart or pie chart etc.?
3
When we save a report in reportstudio with what extn it save?
4
What is query subject?
5
What is the difference between macros and prompt?