Interested to Buy Any Domain ? << Click Here >> for more details...
Where do you edit cognos sql in report studio?
- 3 Answers
- 14871 Views
- HCL, I also Faced
- E-Mail Answers
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 |
Difference between cognos report net and cognos8
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
which table we load first in DW. dimension or fact? why?
4 Answers IBM, JPMorgan Chase,
What is Render Variable? where u can use?
write a query to display the third record from the employee table?
I want to schedule the report as sysdate-1.....how to do
Can you define drill across?
What are the advantages of shortcuts?
What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?
----------------Describe DWH Architecture?
What is the use of cognos decision stream?
Teradata 
