Skip to Content
avatar image
Former Member

variable at bex

Hi

i had created a query at bex and created variable  and had kept mandatory and kept interval option and is ready for input settings i had done and kept that variable at filters characterstic restrictions i had tested at rsrt and it worked fine but when i am trying to create bo report in selection screen when i am refreshing it was striking me error problem in source system do i need to do any settings for that variable and variable is characterstic variable and it is  manual input/default value can anyone please tell me the solution

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

12 Answers

  • Dec 31, 2014 at 07:37 PM

    Hi,

    Please have a look at document Best Practices for Integrating SAP BusinessObjects BI 4.x with SAP NetWeaver Business Warehouse (BW) and SAP ERP. Amongst others the BEx Query Elements are evaluated on supported meta data and functionality. E.g. on slide 34 of the presentation you can find an overview of the different variable presentations for the different BusinessObjects front-end tools.

    Best regards,
    Sander

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 02, 2015 at 08:46 AM

    Hi Sander

       Thanks for your reply we are not using design studio  we are using web intelligence rich client and i had tried with rsrt its working fine i run the query at rsrt its working fine only the problem is from bo

    actually i created a flow with dso and cube and i had done reporting on top of cube and i thought  variable is in $tmp and i created a package for it and had tried again but no resolution i had tried keeping all types of variable represents single value and several values and interval but what i tried all its working in rsrt but not in bo i kept selection 0employee in filters and created a variable of type characterstic processing by manual input/default value when trying to execute in bo web intelligence rich cient when i am selcting 0employee and doing refresh means i am getting this error 

    ERROR BRAIN (629): Specify a value for variable

      MSGV1:

    ABEND BRAIN (670): An error occurred when getting data from the processor.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 02, 2015 at 10:51 AM

    Thanks Sander

    The two notes were not able to resolve my issue once i will check with my bo team sander now whatever new variable i am creating its hitting same error sander and if i am using already existing variable there is no issues

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 31, 2014 at 12:07 PM

    check connection settings.
    copy the error message and type it on google to get more exact or nearby solution explanations

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 31, 2014 at 12:08 PM

    Hi,

    From Bex query to BO some variables are not supported , check either "Single Values" or "Multiple Single Values"  options available instead of interval.

    Regards,

    Seshu.P

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 31, 2014 at 01:24 PM

    Hi,

    it is the custom varaible if yes it should work if you created the BICS conection.

    how you are getting the data form through BICS or universe connection.

    you will get easely through BICS connection.

    come out form the BO report then check it out

    please share the scrren shot if you have.

    Thanks,

    Phani.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 01, 2015 at 05:01 AM

    Hi Pani

         Thanks for your reply it is characterstic variable processing by manual input and variable represents interval and bo directly connecting from bex and every thing is ok and according to my guess  the problem is with my variable only because if i take away that variable report is working i need any settings to be done for that variable as per my assumption i kept interval so that might not work i am thinking

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      Which BO front-end tool are you using to consume the BEx query?

      It's important to know because the different BO front-end tools support different metadata and functionality. E.g. DesignStudio does not support "mandatory" variables according to the document(slide 32) which I shared yesterday with you.

      Did you try to regenerate the BEx query using t/code RSRT?

      Just to be sure, sometimes it helps.

      Best regards,

      Sander

  • avatar image
    Former Member
    Jan 02, 2015 at 04:13 AM

    Hi

    Again i created variable with variable represents single value and its mandatory and kept ready for input and its characterstic variable and again i tried in bo its hitting an with same error

    ERROR BRAIN (629): Specify a value for variable

      MSGV1:

    ABEND BRAIN (670): An error occurred when getting data from the processor.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 02, 2015 at 04:47 AM

    Hi Still,

    Are you use a zobject?, if yes, can you check how to create this object?, sounds like you have a mark access to datamaster with a bapi, you need change to estandar access.

    If your object is stándar, try unmark mandatory.

    Regards.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 02, 2015 at 04:51 AM

    Hi Francis

      My object is standard and i tried in all ways keeping optional and  mandatory but its not working

    Add comment
    10|10000 characters needed characters exceeded