F4 Value Help for Bex Variable (BRAIN646)

[Former Member]

Hi ,

I set a authorization variable which allow user to select in a Bex query . When I run query and click value help on that variable, the system keep send a warning msg like :

Value if variable ZVAPLAMS is automatically converted

Message no. BRAIN646

Is there any way to suppress this warnning msg?

Thx,

Jeff

[Former Member]

Hi Sims,

I had also the same Problem (BRAIN 646). I've debugged the Query with transaction rsudo -> Execute User as "User with warning" -> Possible Transaction "RSRT" -> Start Transaction.

The Transaction RSRT is opened and you can now debug your Query by klicking on "Execute + Debug" -> Expand "Variables" and activate "Customer Exit Variable (Before)".
Don't forget to enter your Queryname.

You are in Debuging-Mode and set Break-Points (see screenshots)

1. Set break-point on FORM VALUE_FROM_AUTHORITY_FILL then F8 and get in with F5

2. Set break-point on  IF l_i1 <> l_i2. then F8 and you get your cursor on IF l_i1 <> l_i2.

You may see, if internal tables "l_i1" and "l_i2" have the same count of rows. If not take a look at   "l_i1", if there Interval value exist, if internal value do exist. If interval values do exist and in "l_i2" doesn't than you have replace your variable " ZVAPLAMS" with another Variable (selection option). It has to be "Selection Option", than only selection option variable accept single values and interval values.

Regards

Wanda Soetomo

[Former Member]

Hi All,

I am confused by the solution

The solution is to use value variables filled from authorizations in combination with selection type "Select Option".

How do we fix this. We also have a query that they are running and we are getting the BRAIN255 message but my trace in RSECADMIN refers to BRAIN646 and 629.

The users who have 0BI_ALL can make the selections no problem and have the correct company codes returned. The users who are limited to 3 company codes have the issue where they enter the code and it always returns the other one that is in the selection. How can we fix that?

Thanks,

Mary Sims

[Former Member]

Hi Jeff,

you have to use an option in the BEx toolbar -> Settings -> Suppress warnings from the server.

Hope it helps.

Bye,

Roberto

[Former Member]

Hi Roberto,

I have done that. But, still got the popup msg.

Best regards,

jeff

Message was edited by: Jeff Huang

[Former Member]

Hi,

I would be very interested in how you solved this because I am getting the same message and cannot get rid of it. I went to RSRT1 but that warning message doesn't even show up for me to suppress it. Any thoughts would help.

Thanks,

Cherie Murphy

[Former Member]

Hi,

we got the very same problem here and if anybody has found a solution by now, please let me know!

Thanks,

Jörg

[Former Member]

Greetings all,

I've the same problem. I have a authorization variable linked to 0SALES_ORG. The system kicks out this message when you have more than one value assigned to your auth. object i.e. "1000, 2000, :"

Unfortunately I've not yet found a solution but maybe this will help other in their search.

[Former Member]

Hi,

The BRAIN646 message is caused by a value variable that is populated by authorizations. The user has

authorized values that do not fit into this variable; i.e. multiple values into a parameter variable or intervals into a parameter of multiple single values variable.

As a result the values from authorization that do not fit into the variable are ignored. This produces the warning message you get.

The solution is to use value variables filled from authorizations in combination with selection type "Select Option".

Hope it helps.

[Former Member]

Thanks for that.

It works now.

[Former Member]

Hi,

I am also facing the same issue with Bex Variable .

I tried what you mentioned here. It works perfectly. Thanks for your advice.

But I want to display the values in my authorization object in the selection list.

At present no values are displayed for selection, other than the initially selected one.

Can you help me on this?

Thanks in Advance

Shobin