Cognos Data Warehouse Interview Question:

What is the difference between group and associare?

Submitted by: Administrator

Group: used to eliminate duplicate values in the report.

Association: used with grouped item that displays data only when the values are changed.

ProctLine ProductName Quantity Revenue

--------------------------------------------------------

Soaps LUX 100 1000

200 2000

300 3000

TIDE 100 1500

SHAMPOO GARNIER 100 4000

200 8000

SUNSILK 100 5000

--> Here, ProductLine is a grouped column and ProductName is an Associated column.
Submitted by: Administrator