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
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
please please give me some banking calculations in framework manager.
what is hints in cognos and where we use it.
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
Which studio is used to create reports?
Can you define cube?
What are the different types of important services used in cognos?
What is the use of Cognos scenario?
How can I test reports in cagonos?
tell me two or three issues from client side and how to solve those issues?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
What is the difference between Standard and Metrics folder?
what are the dimensions that you have in your current project?list them?
how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com
How can I schedule reports in cognos?