Where do you edit cognos sql in report studio?
Answer Posted / 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 |
Post New Answer View All Answers
Can you define slice?
what is model and say about process how to create model and how to test model?
What is the use of Cognos scenario?
What are the batches and it’s details?
When we save a report in report studio with what extn it save?
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
What are the types of studio?
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
How do we drill through from a powerplay cube to reportnet?\
What are various types of gateways in cognos?
Can you explain a cognos controller?
Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!
Can you explain the advantage of using shortcuts?
Write various indexes used in cognos?