Skip to Content
author's profile photo
Former Member

Numbering the top 10

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    author's profile photo
    Former Member
    Oct 04, 2005 at 07:23 PM

    U can achieve this in BEx.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Oct 05, 2005 at 02:07 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Oct 07, 2005 at 12:26 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Oct 05, 2005 at 11:47 AM

    Hi,

    You could use the Table Interface and simply add

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

    Kind Regards,

    Alican Polat

    Add comment
    10|10000 characters needed characters exceeded