Where do you edit cognos sql in report studio?

Answer Posted / srini madhala

1. Pause the pointer over the query explorer button and
click the query you want.
2. In the Properties pane, double-click the Generated
SQL/MDX property.
3. Click Convert.
4. Make the changes you want.
If you are working with MDX, you must be aware of the MDX
syntax that Report Studio
supports.
5. Click Validate to check for errors.
6. Click OK.

Is This Answer Correct ?    7 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the main services provided by application tier?

560


How can create users and permissions in cognos?

559


Can you explain cognos planning?

660


Cleared COG-112 with 100% score today. What next certification should i go for?

1414


What r the names of the reports that you prepared?

563






What are shortcuts? Where it can be used? What are the advantages?

551


Why are meta service important then other services?

582


What is looping and how to avoid it in framework manager?

661


What is a Folder?

677


how can you get the errors in job? when loops are araised we get error?

1649


What are the advantages of cognos?

570


Can you define drill down and drill up?

635


Why cognos decision stream is used?

636


I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series

1708


What do you understand by user class in cognos?

534