Maximum Values permitted in a Multiple single value Variable in BEx

[Former Member]

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

[former_member184494 · Accepted solution]

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

[Former Member · Accepted solution]

Unfortunaly i cant use a precalculated value set or exclude condition. The BW query is being called from an external application using OLAP BAPI with MDX, Thanks for your answer though.

[Former Member · Accepted solution]

Hi Sanjay,

Did you have any success in passing a larger variable range? I have a qury that needs about 10,000 variables to be passed to it and I was wondering if there is way to overcome this limitation.

Thanks.

[Former Member · Accepted solution]

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)