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

Maximum Values permitted in a Multiple single value Variable in BEx

May be you guys have faced this kind of situaiton - I am popultaing a Customer Exit Variable ( Multiple Single Values ) reading a db table and looping through the internal table ...etc..But when the internal table(variable output range) contains more than 3000+ rows i am getting bunch of different errors. Suppose if the number of values passed to the variable is less than 3000 it works fine. I am wondering if there is some setting /parameter we can set that will increase the limit. I searched oss etc but of no use. I am on BW7.0 SP15. Any ideas are welcome..

Sanjay

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Dec 15, 2007 at 06:07 AM

    Sanjay,

    This would be because of the SQL query size , the SQL and internal table used for the same cannot exceed a particular size - imaging haveing 3000+ where clauses in an SQL statement.

    This is a system limitation and am not sure if anything can be done from BW as such - things that could help you are :

    1. If the selection is 3000+ can you have an exclude condition with lesser values ?

    2. Try using a precalculated value set from another query to feed into the same .

    My 0.02

    Arun

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      For my scenario i am using another approach and it is working fine for me now.

      if you are interested- In my scenario i have to poupulate all Like values for a given input string for example if user want to see all PO number that start with TEST (like test 1 , test2,,etc ) the number of like values is more than 3000 for me. Also the user can enter individual PO number also , for example a search can be (TEST* + SANJAY), so i am restricting my infoobject to variable of type selection option (processed by customer exit) and i am taking the input in Multiple text variables, i customer exit i use OPT = 'CP' ( TEST* in this example )which populates the like values and appending the indvidual PO number( SANJAY in this case) to the output var range .. also in the scenario these reports will not the run in BEx but will called from a java apps using MDX, so i have the choice to format the results like i want in MDX ( using calculated Members)

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.