Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

hi How Can we create rank in our report?i feel difficulty
pls expain me with ex,pls pls........

Question Posted / guest

Answers were Sorted based on User's Feedback



hi How Can we create rank in our report?i feel difficulty pls expain me with ex,pls pls..........

Answer / annareddy

If u find the top 5 sal :
Create quires with Product type, Quantity, create Rank
column with rank(quantity)
Query1 give filter Rank<=5
Change the filter Application property from Before Auto
Aggregation to After Auto Aggregation.

Is This Answer Correct ?    2 Yes 0 No

hi How Can we create rank in our report?i feel difficulty pls expain me with ex,pls pls..........

Answer / srini madhala

Think you have 4 dataitems in report, 1 column as salary.
So if you to find top 5 salaries then:-
rank(Sal)- Ranking Displays the ranks of the salaries based on there values.

running-cont(rank(Sal))-Top provides you the top salaries and least salaries. For example to show top5 salaries.
top<=5 display top5 salaries

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Cognos Interview Questions

How can I convert a list report/Cross tab Report in Cognos EP series into a bar chart or pie chart etc.

5 Answers   IBM,

what is Galaxy schema??

2 Answers   IBM, iGate, Wipro,

-------------How to do Bursting a Report?

1 Answers   Cap Gemini,

I have Date,product,Quantity_Sold columns and I want Product, MTD(month Till date),YTD(Year Till Date) as output. Can anyone help me with the logic in getting MTD i.e quantity sold from 1st of this month to till date (i.e. 01- 11-2013 to 26-11-2013) and YTD i.e QTD sold from 1st date of the year to till date(i.e. 01-01-2013 to 26-11-2013). Sample output model: Product MTD YTD

1 Answers   L&T,

How to create a Left Outer Join in FM? Please explain.

2 Answers   Cisco,

how you create security to reports?

0 Answers   IBM,

Explain how data modeling is useful to cognos in daily life?

2 Answers  

How to identify in report that is apply as a detail or summary filter?By looking the report have to identify the report has applied as detail or summary filter to that report?

1 Answers   Mind Tree,

What is the difference between low affinity and high affinity connections?

0 Answers  

What are various types of gateways in cognos?

0 Answers  

Hi Friends,what are The Advantages In Cognos 10 Compared To Cognos 8.4?Enhancements in Cognos 10? Please Ans Me Pls

1 Answers  

In one of my report i have one data item sales_amount. If this report is run by one user from india so the sales_amount should be display in indian repees(Rs.) format, if USA user then in dollers($), if UK user then In Pounds.Hou can i achive this? Please answer me.

4 Answers   Accenture, HCL, IBM,

For more Cognos Interview Questions Click Here
Categories