write a query to display to 10 max record from the employee
table?
Answer Posted / don
we can create a list report and sort the field which we
need the top 10 of in an descending order and before
running the report set rows per page to 10
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
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
----------------Diff b/w Dimensional modeling and Relational modeling?
Can you define metrics designer?
Can you define snapshot?
What is the deployment requirements used in cognos?
Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com
What do you mean by drill across?
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 ?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
Tell me about Dnamic and Static Dashboards?
What are the types of hierarchies?
How to a create header dynamically in a crosstab report in cognos 8.1?
What is a Folder?
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)