What is Cardinality
Answers were Sorted based on User's Feedback
Answer / itesh biswal
Simple man
carnality and join are 2 diff things ,u can see in ur
cognos application u will be having 1:n the first part
explains u about the join and the second part tells u the
cardinality ,if in ur 1st part its 1:1 then equi ,if 1:0
then outer if 0:1 then outer if 0:0 its full outer
and the second part tell u the cardinality remember
cardinality never change the query output ,it only identify
the fact and dimension which is very important ,u remember
if u have muti-star schema then it should write two query
depend on two fact ,so pls do it correctly ,
1:n represents fact
1.1 represents dim
Check where is ur measure, put many in that cardinality
Cheers
Is This Answer Correct ? | 18 Yes | 0 No |
Answer / bhaskar reddy
cardnality is the nature of the relationship. 1-1,1-many
relation ships
Is This Answer Correct ? | 13 Yes | 1 No |
Answer / bijayapanda
cardinality is nothing but relation between tables like 1
to 1, 1 to many and many to many.
Is This Answer Correct ? | 13 Yes | 4 No |
Answer / shaik .mahaboob basha
cardinality specifies the nature of relationships between
the query subjects.
it is numeric notation .
the first type says about the type of join ie.,inner or
outer join
and second one says about the number of records
Is This Answer Correct ? | 12 Yes | 3 No |
Answer / p.krishnamohan
Cardinality is defined as howmany times a value of a p.k
can be used as a f.k in the dependent table.
Is This Answer Correct ? | 7 Yes | 4 No |
Answer / bhoom
cardinality is the nature of the relation between two
query items
Is This Answer Correct ? | 7 Yes | 6 No |
What is Cognos Mashup Services .what is the use of Cognos Mashup Services and where to use.
write a query to display the departments with no employee?
suppose a value prompt contains 100 values and i want to select all values in that prompt....i want ALL option in the value prompt? how can u keep this option in value prompt?
How much time it will take to develop a report in real time? It depends upon the complexity of the report, so tell me the approximate time period for a simple list, cascading, master-detail, drill-through,..…etc?
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
4. How many dimensions did you use in your reports?
hi Here ive question on Reportnet when we save a report in reportstudio with what ext it save
------------- How to identify the Revenue Column in Report?
What will happen if scheduling a report with a prompt page?
i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?
What is the difference between set functions and filter function in dimensional data?
what are the enhancements in cognos reportnet ?