How to get Top 10 Customers based on Net Sales using variable?

[former_member354226]

Hi Experts,

We are working on Webi report based on Bex query.

Right now we have more than 2.5k customers in the database. When I take customer dimension in input control, it takes a lot of time to load input controls. That is why I want to show only top 10 customers in the input control.

I want to create Dimension variable which will give me list of top 10 customers based on Net Sales.

I tried using the Rank function but when I drag that variable to report its showing #CONTEXT and #MULTIVALUE error.

How to create this variable?

Thanks

[former_member250413]

You can use the ranking to do this, follow a link that explains how to use:

http://www.bidw.org/business-objects/web-intelligence/ranking-data-in-web-intelligence-report/

[former_member354226]

Hi Graziano Oliveira de Morais,

Thanks for the reply.

But I don't want to show top 10 customers in Table. I want to use them in the Input control.

Right now we have more than 2.5k customers in the database but I want to show only top 10 in the input control.

Regards

[former_member250413]

Pan Kaj,

Inside the webi, I can not see a way for you to do this.

If you use the function that rank or runningcount for example it will only display the value 1.

Maybe one output is to create a calculated field in your bex query so that it can be used in the input control

[kohesco]

Hi,

• sort your table with the measure descending
• add variable rowcount

  =RunningCount(1)

• filter table on rowcount less than or equal 10

[former_member354226]

Hi Koen,

Thanks for the reply.

But I don't want to show top 10 customers in Table. I want to use them in the Input control.

Right now we have more than 2.5k customers in the database but I want to show only top 10 in the input control.

Regards

[kohesco]

You could work with element linking from that table on (best to create the top 10 via ranking than also, no special variable needed)

something like this