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 |
Mention the difference between ‘macros’ and ‘prompt’?
What errors and types of errors you faced in Cognos ReportNet?
what is the difference between Cognos EP7 series and Congos8?
How to upgrade drivers in Cognos 8?
2. What functional area you worked on.
what is stitch query?
What is called cognos reporting tool?
What is the concept of using Dimension allocation "By Measure"? How Transformer use when computing the Base measue?
what is the difference between cognos8 fm and cognos reportnet fm?
write a query to display the third record from the employee table?
How to Create users in cognos Access Manager from 1) front end 2) back end
There are some reports,we have to provide security to that reports like the hr manager should have access to hr department reports only and the accountant should have access to accounts reports where as the CEO can have access to all the reports. How to deal with this situation using Cognos?