Where do you edit cognos sql in report studio?
Answer Posted / raju
copy the report to notepad to view the sql query for the
report. then you can play with the queries.
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file
Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com
Explain informatica architecture?
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?
What do you understand by the term 'aggregate advisor?'
What is the size of database for you project?
4. How many dimensions did you use in your reports?
Define report item?
What is the size of the cube?
What you mean by drill across?
Explain the difference between native sql and cognos sql?
------------- How to identify the Revenue Column in Report?
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
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?
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance