what is the difference between group and association?
Answers were Sorted based on User's Feedback
Answer / guest
In cognos 'group' is used to suppess the duplicate
values..and 'associate' is used to suppress the values if
it is one-one relationship.
| Is This Answer Correct ? | 12 Yes | 3 No |
Answer / vidya
When we group data, Cognos sorts the data item as we
grouped and removes duplicate values. We can organize our
report by grouping on one or more data items.
By associating a grouped data item to another data item we
can eliminate duplicate information from our report. We can
associate one or more data items with a grouped data item.
An association is a group of users joined together for a
purpose. Both group &Association eliminates duplicates
value but we can not use association alone.. An associated
data items hould 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 Correct ? | 7 Yes | 3 No |
Both Group& Association eliminte duplicatesin a column.
But we can not use Association alone.
It should have one to one relationship with grouped column.
Using Association is a performance enhancement technique.
| Is This Answer Correct ? | 5 Yes | 3 No |
Answer / user
A GROUP IS USED TO ELMINATE THE DUPLICATES IN DATA.WHERE A
ASSOCIATION IS USED TO HIRE OR SUPPRESS THE VALUES IN 1 TO
1 RELATION.
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / rajitha
Group - It Eliminates the Duplicate values from the report
break the columns . its having a one to many relationship.
Association-
It Eliminates the Duplicate values from the report and its
having one-one relationship....
| Is This Answer Correct ? | 2 Yes | 5 No |
How can we find out cardinality between two tables?
1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE
what r the filters in fwm and report studio
What is difference between drill through and drill down?
2. What is With Clause In Cognos?
how to create relationship between emp and salgrade tables in frameworkmanager?
3. Differences between Cognos Sql & Native Sql? What are their Advantages and Disadvantages?
I am currently pursuing a career in Cognos and need your support in the same regard. I am in the position that you were in as described above. I would like you to share your experience during interviews, project explanation, on the job etc. I am preparing for the interviews and am quite nervous about cracking it. I am sure you understand the anxiety. Your help will be greatly appreciated. Awaiting your response!
Hi All, When user run the cognos report, that report output data must be download/available in EXCEL / CSV file.? (like... list report contain PL,PT,PN,RVEN, that excel/csv default download must be list columns PL,PT,PN,REVN) Thanks in Advance, LN.
actually my qus is i used some tables in my model,i published that to connection i use that one.at the same way my team member added some new tables and again he published how can i get my model in connection pls pls explain me..........
Can you define slice?
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?