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
Explain is there any comparison available for cognos reportnet vs crystal reports?
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
what is power prompt in cognos ep7series?what is the use of this?
How we check the errors before running the report?
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
What is the difference between the standard and metrics folder?
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 ?
Cleared COG-112 with 100% score today. What next certification should i go for?
Can you explain new content durability?
How to publish a package by running Java Script?
what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?
What do you understand by user class in cognos?
What is the difference between Open Connection command ang Open Session Command?
What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?
What are the considerations regarding performance kept in mind while setting up cognos?