Where do you edit cognos sql in report studio?
- 3 Answers
- 13822 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 |
Hi..I have COG-112(Report Author),COG-122(Admin),COG-132(Meta data modelling). I took test end of Sep '09.I got 100% wcore with these dumps. If any body need then mail me on kris.bi121@gmail.com
What is the abrevation of .PPR? (Power play report) or anything new?
What actually a project contains?
After installation of Cognos Reportnet how do i know how much of entire Cognos server is being utilised at any instatnt of time?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?
what is conditional query subject and example
Hi Friends,what are The Advantages In Cognos 10 Compared To Cognos 8.4?Enhancements in Cognos 10? Please Ans Me Pls
I have tables like tableA&tableB,in tableB columns(sno,month,netrevenue,year),by using both the tables we hava to create list columns like(country,month,net revenue)when i run the report if my retrevenue'0'this plasa i want to display'NULL'
What is the difference between low affinity and high affinity connections?
How do you use SUM function in Reportnet?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
Teradata 
