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


Please Help Members By Posting Answers For Below Questions

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

1938


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

1630


Explain informatica architecture?

559


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?

2082


What do you understand by the term 'aggregate advisor?'

537






What is the size of database for you project?

1106


4. How many dimensions did you use in your reports?

1489


Define report item?

664


What is the size of the cube?

533


What you mean by drill across?

612


Explain the difference between native sql and cognos sql?

506


------------- How to identify the Revenue Column in Report?

1818


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

1824


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?

4209


can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

1870