Where do you edit cognos sql in report studio?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / 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 |
What is difference between data mart and data warehouse?
How do you improve the performance of the Cognos Analytics report
What is the use of 'individual data source' option while using filter in query studio?
Due Date (Highlight Issues in Blue where Due Dates are less than Todays Date),I have only Due Date column then how to over come the problem.How to find out which Due Date are less than Today Date...Kindly provide the detail steps to my mail ID-->asimcognos10@gmail.com
what is degenerate key in oracle ?whare do we use it?
Hi all, IF any one has Cognos Dump Questions please send it to my mail ID : jaya.purna@gmail.com Cheers Jaya
What is the importance of Dimension in the cognos.
HI,can one suggest best institute for cognos Training in Hyderabad
what is Galaxy schema??
What is the difference between Standard and Metrics folder?
Which service handles requests for cognos connection,query studio and event studio.
What is the report studio?