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 |
In one of my report i have one data item sales_amount. If this report is run by one user from india so the sales_amount should be display in indian repees(Rs.) format, if USA user then in dollers($), if UK user then In Pounds.Hou can i achive this? Please answer me.
4 Answers Accenture, HCL, IBM,
What is meant by Tabular SQL in Cognos Report net
How can I schedule reports in cognos?
How to findout YEAR CALCULATION? THAT MEANS YOU SHOW THIS YEAR REVENUE AND LAST YEAR REVENUE. WHEN YOU FILTER THIS YEAR VALUE THE RESULT SHOULD DISPLAY THIS YEAR RESULT AND LAST YEAR RESULT.
What are the differences between cognos reportnet 1.1 report studio and cognos 8 report studio?
What is slicer & dicer ? what is sub session parameter ?
Can you define drill down and drill up?
Define query items?
Where do i get Cognos 10 BI Online Training in Low price for the below tools. Cognos Framework Manager Cognos Report Studio Cognos Query Studio Cognos Analysis Studio Cognos Event Studio Cognos Transformer Cognos TM1 Development
Can you define a query subject?
how can I test reports in cagnos?
What are the advantages of shortcuts?