Cognos - what is the difference between group and associare?

GeekInterview.com > Interview Questions > Data Warehousing > Cognos

Go To First | Previous Question | Next Question

Cognos | Question 27 of 180

what is the difference between group and associare?

Total Answers and Comments: 4

Last Update: March 27, 2007 Asked by: Jash

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

May 15, 2006 13:41:55

jyothsna

RE: what is the difference between group and associare...

When you group data Impromptu sorts the data item you are grouping and removes duplicatevalues. You can organize your report by grouping on one or more data items.By associating a grouped data item to another data item you can eliminate duplicateinformation from your report.You can associate one or more data items with a grouped data item. An associated data itemshould have a one-to-one relationship with the grouped data item. For example Order No. is agrouped data item. For each order number there is an Order Date. Order No. and Order Datehave a one-to-one relationship.

Is this answer useful? Yes | No

June 23, 2006 07:53:22

RE: what is the difference between group and associare...

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.

Is this answer useful? Yes | No

March 27, 2007 07:13:53

rkiranbedi

RE: what is the difference between group and associare...

Group is used to Eleminate Duplicates

where as associate is used to make grouped item in one to one relationship manner.

ProctLine ProductName Quantity Revenue--------------------------------------------------------Soaps santoor 100 1000 200 2000 300 3000 Lux 100 1500SHAMPOO Chik 100 4000 200 8000 Velvet 100 5000

Here Proct Line is applied by group.

and Product Name is applied by Association.

Is this answer useful? Yes | No

March 27, 2007 07:27:57

rkiranbedi

RE: what is the difference between group and associare...

group is used to eliniminate Duplicates

Where as Association is used to make one to one relation ship between to columns.

ProctLine ProductName Quantity Revenue--------------------------------------------------------Soaps Rexona 100 1000 200 2000 300 1000
Santoor 100 1500SHAMPOO Chik 100 4000 200 8000 Velvet 100 5000

here Produce Line is applied by Group
and Product Name is applied by Association

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank