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 various types of gateways in cognos?

538


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

1647


Define the slice and dice?

567


Explain what is the main advantage of impromptu over cognos reportnet?

595


Can you define drill across?

559






What are slice and dice?

521


What is the difference between a data mart and a data warehouse?

539


What are the components used in web tier?

529


What are all the types of gateway used in Cognos?

544


what is catalog and types of catalogs in cagnos and which is better?

681


What is the difference between Open Connection command ang Open Session Command?

1912


What are the advantages of cognos?

564


How can we create a dynamic column name in cognos?

525


what are the dimensions that you have in your current project?list them?

1628


What errors and types of errors you faced in Cognos ReportNet?

3478