cancel
Showing results for 
Search instead for 
Did you mean: 

Percent of business partner

Former Member
0 Kudos

Hi All

I want to add a condition to my query that return a certain number of business partners (based on percentage). If I use the Top % i condition I can only reference my key figures and not the characteristic 0bpartner.

Ex: Give me 70 % of my best business partners based on revenue. If i have 1 million business partners i would like to receive 700 000 in my query.

Any suggestions?

Erik

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

I hope, the conditions on the query will help you.

But to make the user can enter the value for Condition , we have to use web template with web item: 'Condition'

With rgds,

Anil kumar Sharma .P

Former Member
0 Kudos

Hi again

Thanks for replying my question. As far as I can see, the conditions can only be set for key figures. When using the percentage function the values of the key figures are aggregated until you reach the desired percentage. My problem is that I want a percentege of the users. Not the users the together has the desired aggregated value of their key figures.

Is this possible?

Erik

Former Member
0 Kudos

Hi,

I hope, the using of formula functions (like %GT or %CT) with the conditions may help you.

With rgds,

Anil Kumar Sharma .P

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Erik,

I don’t think that you can achieve it directly in BEx.

The reason is the following: all percentage functions in the BEx formula builder will work on a KFs values, not on number of records in master data table.

Using user exit will not help either. You can determine a definite percentage of bpartners reading master data table and populating exit variable with multiple choices. But, you need to select this percentage according to revenue, right? Revenue will depend on selections: time period, regions, types of bp etc. You cannot know beforehand which selection criteria the user may apply. Hence you cannot get needed percentage BEFORE query execution.

The only way, IMHO, to achieve it to execute a query with a condition for, say, Top 99.99% (in order to get the list sorted). Embed this query into worksheet of the workbook. Here should be an exit variable within the query (even might be the 2nd query) which will return (and show in the result area or in the variables and parameters header) the number of distinct bpartner codes. In the neighbor sheet using VBA macro copy the needed percentage of rows and show them in the second sheet.

Best regards,

Eugene