Cognos Data Warehouse Question:
What is the difference between group and associare?
Answer:
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.
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.
| Previous Question | Next Question |
| How do add dynamic titles in PP? | What is Cognos Visualizer and Cognos Scripting? |