Numbering the top 10

[Former Member]

Hello BW Experts,

We need to give the first column in the top 10 customers report as the serial number from (1...10).

sol1) storing the serial numbers statically in the cube is not possible because, the time period selection in the query is dynamic, the user can select the top 10 customers in any period like month, day, week, year.

Sol2) One probably way of achieving this is using virtual chars.

sol3) ???

Q1) Please suggest any alternate way of getting the serial numbers for the cust top 10. ?

Q2) Is there any standard functionality to achive this?

Any suggestions highly appreciated.

Thanks,

BWer

[Former Member · Accepted solution]

U can achieve this in BEx.

[Former Member]

Hi,

just use dispay single value as... rank option (in the properties of the structure element). If you want to see the original value and the rank number, just use your strucuture element twice and for one just set the properties accordingly.

Heike

[Former Member]

Hi, I dont know if you can achieve this or not but its an idea,

<b>

Create a Condition for top 10 at the query level, doing so you have your top 10 customers, now create a Modify class, and append new column number at data_cell or Characterstic_cell level.. I think this should be easy. I_Y and loop through the table to add 1 to 10..

or

use javascript and loop through the table and create a new column with 1 to 10.

</b>

let me know if it helps you.

Deepak Kunavarapu

[Former Member]

Hi Alicon and Deepak,

Thanks for your replies. Wondering if there is any document or any link where I can find the steps. I am sort of new this topic. wondering if possible if you could send me any documents related to implement this.

mountain.hawks@gmail.com

Thanks,

BWer

[Former Member]

hi,

check this link

http://help.sap.com/saphelp_erp2004/helpdata/en/d8/f3a83adae1a010e10000000a11402f/content.htm

deepak kunavarapu

[Former Member]

Hi,

You could use the Table Interface and simply add

I_Y (which is the line number) to your output.

Kind Regards,

Alican Polat