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 |
what are slowly changing dimensions? Why we are used scd?
For example I developed some reports on employee package now I have to develop same reports to another package.How can I change reports to another package?
what are the dimensions that you have in your current project?list them?
what is dynamic sort?
1.Can we use 2 packages in report studio at a time is there any alternative for this? 2. What are Star Dimensions and Star Facts? 3.What are dimensions and facts in project ? 4.What is difference between 3 NF and Star Schema ? 5. What Is Data Modelling? 6. How much time do u need to create a report ,if u have four dimensions and 1 fact ? 7. How do u create a Model ? 8. How do u connect a Parameter in a list ,such a way it has to show relative objects in Cross tab ? 9. To display region list in separate pages ,how do u do ?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
how can create a report like if the salary>50,000 display balance,if salary<50,000 display green?
How the Bursting happens in same report and how to Print the bursting Report?
Which service handles requests for cognos connection,query studio and event studio.
What is the basic relationship between measures and dimensions in transformer modelling
how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com
what is an associated query?