Where do you edit cognos sql in report studio?
Answer Posted / 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 View All Answers
What do you mean by Drill down and Drill Up?
what is power prompt in cognos ep7series?what is the use of this?
What is the function of model design accelerator?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
What do you understand by the term 'aggregate cache'?
Give me any example of semi and non additive measures?
what are the dimensions that you have in your current project?list them?
What is the use of powerplay web viewer in cognos?
What are the message flows?
How do we drill through from a powerplay cube to reportnet?\
hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
What is the difference b/w macros and prompt?
What do you mean by query studio?
What is the use of powerhouse?