Bypassing the selection screen

[Former Member]

Hi all,

We are using the standard queries from Sales Overview Cube (0SD_C03) and execute the queries in EP as well as Query Designer, Query Analyzer.

We would like to bypass the selection screen and show the report directly. But after displaying the report, if we click on the "Variable screen" button we should be able to get the variables (selection screen) screen (which means we cannot remove the variables directly from the query).

Is there a way of doing it? Any inputs to solve the issue will be very helpful.

Best Regards,

Ram.

[former_member188325]

HI,

If you <b>don't have any 'mandatory'</b> variables and also you have 'force variable screen display' in the WAD <b>unchecked</b>, you will not get selection screen initially.But when you click on 'variables'button WAD...you will get selection screen..

Pl don't forget toassign points to useful answers.

Thanks

[athavanraja]

if you want this feature for webquery (since you are using it in portal i am assuming that you are using it as webquery) just pass the variable value in the query string (format is var_name_1=<variablename>&var_value_ext_1=<var value>&...) alone with &variable=screen='' .

this would pass variable values and wont bring up the variable screen.

if you want to provide the feature of allowing users to change the variable value. provide a link in the webtemplate and the url for this link will be the same query string with variable_scree='X' .

Hope this is clear.

Regards

Raja

[Former Member]

Hi Ram,

did you already try to personalize the variables? Once you did, you will not be prompted for variable entry unless you force it.

regards

Siggi

[Former Member]

Hi Ram,

Sorry for the mistake.. You are right, variables marked with Not 'Ready for Input' are not available for selection, when the variable screen is invoked once the query is executed.

Though variables with the processing type replacement path are Not ready for input by default.

Not sure if the web template property 'force variable screen display' in the WAD could be usefull to shut off the variable screen initially (only if no mandatory variables) ?

Best Regards,

Dabre

[Former Member]

Hi Ram,

When defining the variables for the Query, you can flag the variables as Not 'Ready for Input'. The runtime then does not prompt the user to enter values for such variables, which then could be filled with default values or in an exit.

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/22/1e9b3c334d8c15e10000000a114084/frameset.htm">Related topic on Help.sap.com</a>

Best Regards,

Dabre

[Former Member]

Hi Dabre,

Thanks for the input, but Iam sorry. I forgot to mention that the report 0SD_C03_Q026 uses selection variable defined as "Replacement type" and i guess the solution that you had mentioned doesnot work for that particular type of variable. Is there a way to handle this particular type of variable?

Also if we flag the variables as "Not Ready for Input", after executing the report, i think we would not be able to go back to the selection screen by clicking on the "variable screen" button. Please correct me if my understanding is wrong.

Regards,

Ram.

[Former Member]

Hi,

Your intention in the first place is not to have a selection screen. So, you will have to uncheck 'Ready for input' in the definition of the variable. Hence there is no issue of 'selection screen'.

Regards