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 |
9. What was the most complex type of report you dealt with?
what is a Galaxy Schema?
suppose if u burst the reports if ur reports not reached to the destination how u will identify that one???
Can we create reports using OLTP database?How?
Hi Cognos Experts,I am Having DatePrompt In My Report.I want to display The Report Between Twodates Like jan-SEP How can We Achieve This one?PLS Expain Me With Ex:
if we have a value prompt in a prompt page and if we need to pass that prompt value to a sql used in report, what is the sql code? give me example?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
Can we create a report in cognos BI without a Package? i.e. without framework manager? If so how? I have been asked this question twice..i think this feature is available in cognos 10 version..not very sure....Could anybody highlight?
What is Clipboard? How to import XML file into Clipboard?
What is model filter and query filter?
where you can save the report net documentation in our local system?
Is it possible to join multiple Databases in a Catalog?