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 to improve the report performance?
How do you test the performance of a report?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
How can we find out cardinality between two tables?
can we create master detail report where master and detailed container is separate?
what is physical layer and presentation layer?
What is defined as data mining?
can anybody tell me..how to enter with fake exp..wt r all the documents to carry while attending the interview..how to answer that i am working in..
what are the names of the reports that you prepared?
Cognos TM1 1. What are the different windows in Turbo Integrator? 2. What is the use of advanced window in Turbo Integrator? 3. What is TM1 Workflow. How do you create a process in that? 4. Where is Portlet used. What are differnt windows in portlet. How can you access TM1 web from portlet? Cognos 8. 1. What is Drill-on? 2.How do you implement row level security in Framework Manager? 3. How do you create tree prompt?
What is Regular Dimension and Measure Dimensions and Diff b/w them ?
How you will do the estimation for a task?