Where do you edit cognos sql in report studio?

Answer Posted / sathish

copy the report to notepad to view the sql query for the
report. then you can play with the queries.

for copying the report to notepad( tools -> copy report to
clipboard)

then after editing import by (tools -> load report from
clipboard)

sathishcnpt.938@gmail.com

Is This Answer Correct ?    3 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

----------------Describe DWH Architecture?

1650


How to Reset Pagenumbers in one report.

2209


What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)

1670


What do you mean by Drill down and Drill Up?

570


What is a Transformer?

648






Explain informatica architecture?

558


How Metrics Studio is better than Report Studio?

2030


What is the use of powerhouse?

612


What do you understand by ‘ibm predictive maintenance and quality’?

565


what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?

1501


how many numbers of cubes can we create on a single model? How can we navigate between those cubes?

590


what is stitch query in reportnet?

618


Hi All, I have 1.6 years of experience in cognos in India. I always wanted to do a MS program to earn some money in US. But I think I am little late in taking the decision. As If I have to write my GRE it will be August or September of 2012 and will have to apply for fall 2013 as fall 2012 admissions are almost done now. So my concern is how will be my career do if my MS is at this stage,. i,.e. 3 years experience in Cognos and 2 years MS program in and again looking for job in U.S. Have I been too late in taking the call? I heard that MIS (Managing Information Systems) is having very good placements now. So guys, please advice me in taking the decision to have a good career and also in terms of earning money as I have few financial problems to solve (which I am hoping to solve when I get job in US after completion of my MS program). Thanks a lot friends. I really appreciate and thank one and all for their valuable comments in this site.

4818


what are the features in cognos8ui

1561


Name the types of report?

550