Answer Posted / 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 |
Post New Answer View All Answers
What is difference between primary key and unique key constraints?
---------------Describe OLAP Reporting and RDBMS Reporting?
How is possible this scenario using in type-in prompt.?
What do you understand by user class in cognos?
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
How the Bursting happens in same report and how to Print the bursting Report?
if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......
What are the advantages of cognos?
Can you define dimension?
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
can you tell me what are the dimension tables are used in project
Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
What are initial page components of Cognos connection?
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?