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 |
How to use Cascade Macro in Report studio? Anybody know about Cascade Macro & and the procedure to use?
Explain how data modeling is useful to cognos in daily life?
Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!
What is diffence between query calculation and layout calculation?
What is the difference between List and Cross tab? Could some on explain with an example..
what are the limitations of cognos reportnet? What are the enhancements in reportnet ?
If anyone has COG-185 IBM Cognos 8 Migration Professional Certification Dump, please mail me at: sushma_biswas@yahoo.com
What are the advantages of using cognos sql?
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
What is Outerjoin?
What are the differences between main Cognos 8.2 and 8.3 ?
-------------How to do Bursting a Report?