Thursday, February 28, 2013

[SAP BO] Ranking Data

 


Ranking Data In Business Objects



How to use Rank data in Business Objects(BO) :
 
Ranking enables to look at the largest and smallest numbers in a report. Like filtering, it hides the data you do not want to display. Desktop ntelligence does not delete the data from the report; you can view it again whenever you like by removing the ranking.

Rank can be applied to data in tables, crosstabs or master cells in master/detail reports.

Example: Display the three top‐selling product lines only:



In this example, the table shows sales revenue for the product lines in the efashion retail chain. The table on the left shows revenue for all product lines. In the table on the right, the product lines column shows only the top three selling lines.



To apply ranking:
  1. Click to select the data that need to be ranked. For example, if you want to rank the data for customers, click the column where this data appears.
  2. Click Apply Ranking on the Report toolbar, or click Ranking on the Format menu.
  3. The Select Top/Bottom Variable Name dialog box appears. It displays the options that can be selected for the ranking.


 
  1. Click the ranking values that needs to be displayed in the report.
  2. Click OK or Apply.
  3. The report displays ranked data for the values selected




No comments:

Post a Comment