Where do you edit cognos sql in report studio?

Answers were Sorted based on User's Feedback



Where do you edit cognos sql in report studio? ..

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

Where do you edit cognos sql in report studio? ..

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

Where do you edit cognos sql in report studio? ..

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

Post New Answer

More Cognos Interview Questions

Mention the difference between ‘macros’ and ‘prompt’?

0 Answers  


What errors and types of errors you faced in Cognos ReportNet?

1 Answers  


what is the difference between Cognos EP7 series and Congos8?

2 Answers   Hexaware,


How to upgrade drivers in Cognos 8?

1 Answers  


2. What functional area you worked on.

0 Answers   IBM,






what is stitch query?

2 Answers   Syntel,


What is called cognos reporting tool?

0 Answers  


What is the concept of using Dimension allocation "By Measure"? How Transformer use when computing the Base measue?

0 Answers   IBM,


what is the difference between cognos8 fm and cognos reportnet fm?

1 Answers  


write a query to display the third record from the employee table?

4 Answers   HCL,


How to Create users in cognos Access Manager from 1) front end 2) back end

1 Answers   TCS,


There are some reports,we have to provide security to that reports like the hr manager should have access to hr department reports only and the accountant should have access to accounts reports where as the CEO can have access to all the reports. How to deal with this situation using Cognos?

2 Answers   BitWise,


Categories