Usage of Stored Procedures in Cognos
Answer / rashmi
You can build Query Subject uisng 'Stored Procedure' and then can be used in Reporting.
Is This Answer Correct ? | 0 Yes | 0 No |
What is the importance of having monitor service in cognos?
How to crate cubes in transformer ?
where we use page break and page set. with example?
What is parameter maps & Session parameter?
what does my folder and public folder contains? difference between the my folder and public folder?
How to do Performence Tunning in Cognos Reports?
Use of Text Source Variable in Report Studio?
How do you Parametermap variables in Quiries?
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?
Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks
whis meant by Thumbnails on cagnos?
1. Differebces between Merge and Union In Cognos? 2. What is With Clause In Cognos? 3. Differences between Cognos Sql & Native Sql?What are their Advantages and DisAdvantages? 4. What are different events in Report studio? 5. Create 12 columns for months by writing single case statement? 6. What is Tool Tip?