Skip to Content
avatar image
Former Member

Missing variables when query is refreshed

Hi

We have a report, for which there are 3 user entry variables. When I first run the report, all three show up and the report executes fine. However, if I refresh the query, only one variable shows up. Any ideas on why that could be so? All 3 variables are defined the same way (user entry, optional, selection value).

Thanks,

Pooja.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Apr 23, 2006 at 09:24 AM

    HI,

    please check whether something like 'save and reusable variable values...' is enabled in Query properties.

    right click on result area of Query output-->properties-> there under one of the tabs you see this property...if it is enabled,uncheck this property..and try to refresh the Qyery...

    rewarding points for helpfull answers is the way of saying thanks here in SDN.

    Hope this helps.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 23, 2006 at 08:54 PM

    Pooja,

    Saving and Reusing Variable Values:

    If variables that are ready for input are used in a report, then you can enter the desired values for the variables or confirm the default values when embedding the query in an Excel worksheet. If you wish to save and reuse variable values select the setting Save and Reuse Variable Values. This function is not active by default

    http://help.sap.com/saphelp_nw04/helpdata/en/f1/0a5529e09411d2acb90000e829fbfe/frameset.htm

    -Doodle

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 03, 2007 at 01:46 PM

    Hi Pooja

    I know you posted your question a while ago, but in case you are still looking for the answer, I found it after searching for the answer to my own similar question as yours....

    Go to Change Query (Global Definition)

    In the left hand panel, find the Characteristic Value Variable in question

    Right click, edit

    Un-tick "Can be changed in query navigation"

    It should then appear in the variable selection screen on refresh.

    rgds

    Anton

    Add comment
    10|10000 characters needed characters exceeded