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 |
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
what are the limitations of cognos reportnet? What are the enhancements in reportnet ?
how to do page breaks in cognos 8 Report studio pls give the navigation
if at all asked.wat is u r cube name?wat would be a appropriate answer? plz help me
If you got any problems while developing the reports, then what will you do? How will you debug the problems? This question isasking in many interviews,,,, pls help me,,,
How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
what is the difference between count and running-count functions?
What are the types of folder present in cognos?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.
What do you understand by the term 'aggregate advisor?'
Diff b/w surrogate Key and Primary Key?