What is the difference between group and association?
In cognos 'group' is used to suppress the duplicate values. And 'associate' is used to suppress the values if it is one-one relationship.
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.
Both Group & Association eliminate duplicates in a column.But we cannot use Association alone.It should have one to one relationship with grouped column.
Using Association is a performance enhancement technique.
A GROUP IS USED TO ELIMINATE THE DUPLICATES IN DATA.WHERE A ASSOCIATION IS USED TO HIRE OR SUPPRESS THE VALUES IN 1 TO 1 RELATION.
What is Cardinality?
Cardinality is nothing but relation between tables like
One to One,
One to Many and
Many to Many.
Cardinality is the nature of the relationship. 1-1,1-many relation shipsCardinality is the nature of the relation between two query items
How to test reports in cognos?
You may also test the outcome of a report by writing and executing SQL Queries and comparing the outcome with the report outcome.
BY USING SYSTEM TESTING, UNIT TESTING, PERFORMANCE TESTING
How u create security to reports?
Basically there are two types of securities for any object Levels of Securities:
1. Database level Security
2. Row level security
Even we can provide LDAP security too.
By setting up the Governors in frame work manager also we can give the security to the data accessing through the report.
0 comments:
Post a Comment