Report studio has two SQL tabs one native SQL and another
one cognos SQL which one is get more preference? which one
we need to consider?
Answer Posted / jay
Cognos sql
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
hi friends pls forward impropmtu interview question
what is the procedure for scheduling conditional rendering?
What is looping and how to avoid it in framework manager?
how you migrate reports to cognos 8 from previous versions?
What is called materialized view?
How can I schedule reports in cognos?
Which lifecycle we will use for reporting?
Can you define cognos impromptu?
Can you explain cognos planning?
What is the function of model design accelerator?
What is the use of report studio?
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
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 ?
4. How many dimensions did you use in your reports?