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 the use of cognos decision stream?
How create measures and dimensions?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
Can you define folder?
what is log in cognos?
Explain the difference between powerplay transformer and power play reports?
What do you understand by the term 'aggregate advisor?'
How we check the errors before running the report?
Can you define drill down and drill up?
What is defined as catalog and types of catalogs in Cognos?
How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?
What DB View and Bus View?
How create measures and demensions?
1. Explain your project.
What are the types of catalogs in cognos?