How to create a Left Outer Join in FM? Please explain.
Answer Posted / kumar
select 2 query subjects , then define the relationship 0-1
1-1 if that is between 2 Dimensions.
If that is between dimension, Fact 0-1 1-n {0-1(dimension),
1-n (fact )}
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
Is it possible to join multiple Databases in a Catalog?
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..
what is log in cognos?
What is drill down and slicing and dicing whats the difference between them?
-------------How you design DWH?
What is a Transformer?
How to create a cube in Transformer? What is the process? Please mention process thank u
Can you define a datastore in cognos?
Can you define cognos impromptu?
How can I test reports in cagonos?
When we save a report in report studio with what extn it save?
Can you define confirmed dimension?
what are the filters in framework manager and report studio?
what is model and say about process how to create model and how to test model?