Skip to Content
author's profile photo Former Member
Former Member

Percent of business partner

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 29, 2005 at 08:57 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 29, 2005 at 12:14 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.