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
What are the advantages of cognos?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
Can you define fan trap?
What are the other methods working as deployment functionality?
How Metrics Studio is better than Report Studio?
What are the two types of framework manager?
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
What is meant by junk dimension?
actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....
Can you define drill down and drill up?
1. Explain your project.
What is model filter?
What is metric store database?
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
What is the importance of having monitor service in cognos?