Answer Posted / joydeep
when we pull in facts from different tables into the report
that might be joined using a conformed dimension, cognos
does a combination of coalesce and full outer join to
create a stitch query to avoid the loss of data. when you
go through the SQL generated for the report if you see a
combination of coalesce and a full outer join that means
you are dealing with stitch queries.
| Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
What do you mean by drill across?
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
what do u mean by bridge group? where we r using this one?
where you can save the report net documentation in our local system?
What is Fullouterjoin?
What is a Datastore in Cognos?
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?
what is hints in cognos and where we use it.
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
Can you define cognos decision stream?
Explain the difference between powerplay transformer and power play reports?
What is the difference between static and dynamic conditions?
What you mean by drill across?
Can you explain the advantage of using shortcuts?
Can you define transformer?
