Skip to Content
0
Former Member
Oct 04, 2005 at 06:37 PM

Numbering the top 10

20 Views

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