Answer / itesh

simple man

top 10 alway will be on some measure based on some dim not
simply top 10 and bottom 10,

make q1>
get the rank of the measure rank(measure for dim )<=10
make q2
the rank in the desecending order of measure
rank(measure for dim desc )<=10

make q3=q1 union q2

Answer / arangaraj

Hi,

All are wrong.for ex. if u have list report with
region,staff name and revenue. if u want show top 10 and
bottom 10 performance based on the revenue, drag new data
item from tool box to query item box then expression window
will show in that type like

For Top 10 performance:rank([revenue]desc for [region])
and give name for new query item like Rank or anything.
then drag this new query item to the detail filter window.
then type [Rank]<=10.

For Bottom 10 performance:rank([revenue]asc for [region])
[Rank]<=10.

if u want any query about cognos don't hesitate call me
by mobile:9787642227

Answer / suman

ex. if we have a report with 100 records then

1.select a column which has measures(ex: quantity)
2.click on calculate ,select operationtype as analytic &
operation as rank
3.select the measure col, click on sorting
4.select the measure col, click on filters(in edit data)
5.select combine filters
6.add a filterline
7.select the range as from 1 to 10
again click on add a filter & set the operation as OR &
range from 90 to 100
click ok & run

Answer / z

Explanation is not clear.plz explain properly

Answer / kush

add dataitem rowcount with expression row_count.once it is
done sort the dataitem in the descending order. applying
filter with rowcount<10 gives the solution

Answer / venu

for example if u want to create top ten employees who are
generated max revenue then add new dataitem with expression
rank(total(revenue) for employeename) and in filter
deffination dataitem<10 then u will find top ten records
and for bottom ten records add rownum to column and make
desending order nuw filter for 10 records thats it okayyyyy

Answer / barathi

hi venu can you expalin clearly with example esp for bottom
ten records
thanks

Answer / kumar / nkumar.cog@gmail.com

Hi Guys whenever posting your answers please leave you Email
ID or any contact..........Thanks

Answer / kruthi

By applying conditional format to the required column in
atable we can get top 10 and bottom 10 records in the same
list.
EX:if u want the employees whose sale is greater than 1000
then apply the condition employee sales>1000
then u will get the employees list whose sale is >1000 in
the top 10.
intye same way u can create bottom 10 records in the same
list

How to connect three fact tables?

11 Answers   L&T, TCS,

Any Cognos planning Queries Rise

5 Answers  

What is the model filter?

0 Answers  

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 ?

0 Answers  

How to create multilingual reorts?

4 Answers  

How to test a cube?

0 Answers  

how u provide security to reports??how u provide security to packages ?

5 Answers   Wipro,

What is snapshot thumbnail

3 Answers  

Create 12 columns for months by writing single case statement?

1 Answers   Wipro,

Explain what is the difference between native sql and cognos sql?

0 Answers  

what is power prompt in cognos ep7series?what is the use of this?

0 Answers   HCL,

How to use Cascade Macro in Report studio? Anybody know about Cascade Macro & and the procedure to use?

1 Answers   AIG, Niteo,