Bex variables not working in Webi.

[Former Member]

Hi Guys,

                  I am creating a webi report based on a BEx query. We have variable on Employee from BEX side(optional prompt) when I try to use this prompt and refresh the employee dimension I get the below error. Please help me out of this.

ERROR:

com.businessobjects.sdk.core.server.CommunicationException$UnexpectedServerException: Termination message sent
ABEND BRAIN (670): An error occurred when getting data from the processor.

Thanks&Regards

Krishna.

[Former Member · Accepted solution]

Go through the following should be help full..

http://scn.sap.com/thread/3186250

Limitation's

http://scn.sap.com/thread/1928976

http://scn.sap.com/message/13954659

-Pruthvi

[Former Member]

Hi Krishna,

Did you get the resolution to the above issue we are also facing the same problem.

[jyothirmayee_s]

Hi Priyanka,

Here are the supporting comments based on SAP Note : 1611185

Nearly all variables can be used, however some restrictions exists:

• Variable Types
  For Selection Option variables you cannot enter complex selections, only intervals are supported here.

• Usage of  Variables
  Avoid using input enabled Variables which are used only in Exceptions. Exceptions are not evaluated, and therefore a prompt with no effect will appear.

• Special Considerations for Variables
  To get the possible dimensions / attributes in the query Panel, the BEx Query needs to get instantiated. For this step mandatory variables with no default values are filled automatically by the system with random values. In certain situation the automatic assignment of default values will fail (e.g. Check routine implemented in customer exit
  variables). Please refer also to note 1436769 for a comprehensive list of
  problems.

Validate the Bex variable by executing it in Analyzer or thru portal and if you are facing the same error then do the necessary changes in BW/BEx query.

Thanks,

Jothi

[former_member188911]

Priyanka,

that error shouldn' happen however SP04 was an old SP level, many corrections and improvements have been done in the meantime (we are now in SP08 and SP09 will be released in weeks)

you should please create a new thread specifying the patch level you are on and the workflow that leads to the error

thanks

Simone

[jyothirmayee_s]

Hi,

Does the query have any replacement path varaibles or exit variables?.

Thanks,

Jothi

[Former Member]

HI Jothi

                    I don't have any of them.

Thanks & Regards

Krishna

[Former Member]

HI Jothi

                    I don't have any of them.

Thanks & Regards

Krishna

[jyothirmayee_s]

Hi,

Any filters on navigational attribute?. there must be issue there.

Thanks,

Jothi

[Former Member]

Hi Jothi,

                        There are no filters applied on navigational attributes, there is only one optional variable on employee.

Thanks&Regards,

Krishna

[jyothirmayee_s]

Hi,

Can you remove the variable and drag back, save the query and rerun?.

Specify a value for the prompt, even it is optional?. Is it an Auth variable?.

Thanks,

Jothi

[Former Member]

Hi Hari,

Did you find the root cause for this issue?

I have the same issue, where some Bex Characteristic variables , especially char variables infoobjects with masterdata  (attributes and/or hierarchies) throw errors in webis using BICS connectivity.

[Former Member]

Hi Abhiman,

                            I tried to use the Bex query without mandatory variables, customer exit and user exit variables, by avoiding this I could achieve. Please go through the sap note_0001611185.

Thanks&Regards,

Krishna

[IngoH]

Hi,

which version of SAP BusinessObjects are you using ?

which connectivity are you using ?

does the BEx query run correct in transaction RSRT ?

Ingo

[Former Member]

Hi Ingo.

                  Thanks for the reply.

I am using 4.0 SP4

2)I am using BICS connectivity.

3)Yes it runs well In transaction RSRT.

Thanks & Regards

Krishna.

[IngoH]

Hi,

do you see this error message only for this particular BEx query or does it happen for other BEx queries as well ?

Ingo

[Former Member]

Hi Ingo,

                      I  see this error for other BEx queries also.

Thanks & Regards,

Krishna

[IngoH]

Hello Hari,

do you see it only with queries that contain variables or also with queries that do not contain variables ?

Any issues with another product like Analysis Office or BEx Analyzer or Crystal Reports ?

thanks

Ingo

[Former Member]

Hi Ingo,

             This is happening only for this Query. For other queries with variables its working fine.

Thanks&Regards,

Krishna