Where do you edit cognos sql in report studio?
Answer Posted / 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 |
Post New Answer View All Answers
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
Can you define a query subject?
What is Metrics designer?
------------- How to identify the Revenue Column in Report?
What is the difference between a cascading report and drill through report?
Hi All, I have 1.6 years of experience in cognos in India. I always wanted to do a MS program to earn some money in US. But I think I am little late in taking the decision. As If I have to write my GRE it will be August or September of 2012 and will have to apply for fall 2013 as fall 2012 admissions are almost done now. So my concern is how will be my career do if my MS is at this stage,. i,.e. 3 years experience in Cognos and 2 years MS program in and again looking for job in U.S. Have I been too late in taking the call? I heard that MIS (Managing Information Systems) is having very good placements now. So guys, please advice me in taking the decision to have a good career and also in terms of earning money as I have few financial problems to solve (which I am hoping to solve when I get job in US after completion of my MS program). Thanks a lot friends. I really appreciate and thank one and all for their valuable comments in this site.
explain how to create powerplay reports?
How do you call a store procedure within a transformation?
what is model and say about process how to create model and how to test model?
How to test a cube?
what are the errors faced while bursting the reports and how to solve those errors?
What are slice and dice?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
What is the difference between a data mart and a data warehouse?
Tell me about Dnamic and Static Dashboards?