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
hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..
in u r data u having duplicates how to fetch the latest data in our report?
What is a Query Subject?
Is it possible to join multiple Databases in a Catalog?
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
Can you define framework manager?
What is the model filter?
What do you mean by Drill down and Drill Up?
What DB View and Bus View?
What is set to be cardinality?
Can you define query studio?
How create measures and dimensions?
Explain what is the difference between microstrategy and cognos reporting tool?
What is catalog and types of catalogs in cagonos and which is better?