Skip to Content
avatar image
Former Member

Variable Screen not coming while passing default values in variables

Hi Experts,

We are using BI7.0 and Bex 7.0 and CRM 7.0 version.

We designed a query in Bex Query Designer.In that Query We having characteristics variables which are ready for input from user end.

We have also passed Default values in Variable.

We have added the report in CRM WebUI portal.

Issue is that:-

While executing the report from portal variable screen does not appear.

But when we remove the default values of  Variables in Bex Query Designer then variable screen appear in report for user input.

But we want variable screen should appear while passing default values in variable also.

Please guide us.

Thanks & Regards,

Arpit Gupta

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Dec 31, 2014 at 08:23 AM

    Hi Arpit,

    If you are passing default values to all variables , then it will bypass the variable screen pop-up and will directly give the result.

    If you have any empty variable which you are not filling with default value you can make that variable as Mandatory Variable in query designer.

    Making the empty variable as mandatory will force the variable screen to come up.

    Also please check in transaction code in BW backend system "RSCUSTV27" , and check for for AdHoc Analysis what entry is maintained.

    If entry is blank , then the default template properties used for query is taken from 0analysis_pattern template or if any other template is maintained , please goto Web Application Designer and open the template maintained in RSCUSTV27.

    Please goto properties of web template and check for parameter "VARIABLE_SCREEN".

    If this is set to OFF , please turn it "ON".

    Regards,

    Amit
    '

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Arpit,

      Can you please clarify regarding whether the following which I mentioned here is helpful as it is not clear:

      "Can you please check at runtime by adding &VARIABLE_SCREEN=X at the end of the URL for the report (where the problem is occurring) and check whether it helps you."

      Thanks & Regards,

      Sapna

  • Dec 30, 2014 at 01:06 PM

    Hi Arpit,

    Does the problem only occur in the Portal?

    Please check the query in the BW backend with t/code RSRT and see if the variable pops up here.

    Best regards,

    Sander

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 31, 2014 at 06:22 AM

    Hi arpit,

    Please once check whether the variable popup screen is coming in rsrt.

    and also are u using WAD ?

    If yes, then there is an option under behaviour called display variable. Enable that option.

    Hope u got it,

    Add comment
    10|10000 characters needed characters exceeded