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

Get values through customer exit in BEx

Hi Frnds ,

i have a requirement to read values dynamically based on user entry ,

For Example if a user selects Order = from 3000000201 to 3000000401 while executing a query , i need to get the maximum , mininmum and average days ,

The datatarget will have data like this

Order No Of Days

3000000201 2 days

3000000203 5 days

3000000300 4 days

3000000401 5 days

here the max days is 5 the min days is 2 and the average is 4 days

Hance the query output should have the result like this ,

Order No Of Days Max MIn Avg

3000000201 2 days 5 2 4

3000000203 5 days 5 2 4

3000000300 4 days 5 2 4

3000000401 5 days 5 2 4

Is it possible to achieve this in Bex , Thanks for your valuable sugesstions

If this can be achieved through customer exit please show some draft code sample to achieve this logic

Thanks ,

sathy

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jan 03, 2008 at 09:15 AM

    Hi Satya,

    For the three calculated Key Fig that you have created keep the calculate result as and calculate Single value As option as Nothing Defined.

    And do an Exception Aggregation on all three Calculated Key Fig with Maximum, Minimum and Average of all values with refernce to the Characteristic Order NO.

    Try this out

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 02, 2008 at 02:28 PM

    Hi Sathya.

    You can achieve this if you add the key figure to the structure four times and then go to the calculations tab -> change calculate single values to minimum, maximum and avarage of all values.

    Hope it helps.

    BR

    Stefan

    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.