Force the Variable Screen to Popup After Opening a View (BEx Web Application)

[Former Member]

Hello all!

What I am trying to do:

I am trying to post a link to a web template that will allow users to open already saved views. Once they have opened a saved view, the (date) parameters will most likely be from the last time they ran the report and will need to be updated. So what i would like to do is create this template, have the "Open View" window popup immediately, and then once they select their view (hit "Ok"/"Open"), then have the variables screen open so that they can make any variables changes that they would like.

What I have so far:

I have created the web template and successfully made the "Open View" dialog window popup immediately. All I changed in the code is added these lines between the ACTION_BEFORE_RENDERING/INSTRUCTION tags:

bi:LOAD

bi:TARGET_DATA_PROVIDER_REF value="DP_1" /

bi:OPEN_SAVE_DIALOG_LAYOUT value="TEMPLATE_PERSISTENCY" /

bi:DISPLAY_SINGLE_FILTER_ENTRY value="X" /

/bi:LOAD

The above code works perfectly and does exactly what I need it to do for part 1, that is popup the open view window. Once the window pops up and I select my view, I can't get the variable screen to open automatically. I can obviously click the button and open it manually, but I want to save my users the trouble of having to do that EVERY time.

Someone help me please!!

[RolandKramer]

Hi,

Please check if you Problem is mentioned on this SCN Page

http://scn.sap.com/docs/DOC-35785

Best Regards Roland

[Former Member]

(This is actually in response to both of you.)

Thanks for the quick response!!

I wish it were that easy. If i take my template and run it against a fresh query, it works perfect, the variable screen pops up and all that jazz. But in this case, im not running it against a fresh query, im giving the link to my end users and they are being forced to open a VIEW. This view will already have variables associated with it and filled in because the users have already ran the report and saved it as such.

I don't think it's as easy as setting the VARIABLE_SCREEN=X. I have that set right now and it doesn't change anything because the variables are already populated when opening a view. i have even placed the VARIABLE_SCREEN=X in the URL and same results.

I have the template forcing the users to open a view by placing OPEN_SAVE_DIALOG_LAYOUT inside the ACTION_BEFORE_RENDERING tag. It's almost like i need a ACTION_AFTER_RENDERING tag but i feel like it doesn't exsist.

[arvind_doomra]

Dear Greg,

Try parameters from note  1280069.

Regards,

Arvind

[Former Member]

Alright, so from reading those notes, it seems like I would have to make the following changes in the "Web Template Parameters":

Under "Behavior When Loading Bookmark" change "Use Variable" to Show[SHOW].

Which in theory makes sense to me. It added the following XHTML:

                bi:BOOKMARK_LOADING type="COMPOSITE"

                    bi:VARIABLE_SCREEN_SETTING value="SHOW" /

                /bi:BOOKMARK_LOADING

In theory this makes sense and i had a gimmer of hope that it would work, but unfortunately still no variable screen after opening view/bookmark. I even tried setting the "Use Clear Varilable" to "Clear[CLEAR]" and still nothing.

[Former Member]

In that release note that you have suggested, I also see info about support packages, I currently have:

BI_CONT - 735 - 0005 - SAPK-73505INBICONT - Business Intelligence Content

and

BI_CONT_XT - 735 - 0005 - SAPK-73505INBICONTXT - BI_CONT_XT 735: Add-On Installation

Is this sufficient enough?

[arvind_doomra]

This should not be issue,

I have got another SAP Note 1512750. could you please check if SAVE_VARIABLE_VALUES is selected.

try unselecting the option..

[Former Member]

Hi Greg,

If you are on BI Java 7.3x , you can check note 1801543.

1801543    Variable screen not shown for bookmarks.

Regards,

Amit

[Former Member]

Having the team install the necessary patches from this note (1801543). This describes my exact issue, so I really hope it helps!!

[Former Member]

Hi Greg,

Did you have solution for this issue ?

I've also implemented this Note but we still have this error.

Thanks,

Z

[arvind_doomra]

Hi Greg,

Please set parameter  VARIABLE_SCREEN=X. in your standard web template and retest.

Regards,

Arvind

[sapna_jgurudutt]

Hi,

Are you using any mandatory value in variable screen?

VARIABLE SCREEN NOT SHOWN BY DEFAULT SCENARIOS:
===============================================
1. If a query has no variables, no variable screen will be shown in web.
It is not at all possible to see variable screen in this case.

2. If a query has variables (only optional variables but no mandatory
variables ) then variable screen will not be shown.

3. If a query has mandatory variable but if it is prefilled, then
variable screen will not be shown.

you can enforce to see variable screen only in case 2 and 3 by using the
parameter '&VARIABLE_SCREEN=X' to the end of context url as shown in
example below:

/irj/servlet/prt/portal/prtroot/pcd!3aportal_co
ntent!2fcom.sap.pct!2fplatform_add_ons!2fcom.sa
p.ip.bi!2fiViews!2fcom.sap.ip.bi.bex?TEMPLATE=
<XXX>&VARIABLE_SCREEN=X

The variable screen wont be shown if there are no mandatory variables
in the query.  You can force it with the following methods,
1) Append the parameter '&VARIABLE_SCREEN=X' to the links in your menu.
2) Change the parameter in the web template used   > template property
   'Force variable screen' in the Web Application Designer, per
   default it is not checked.
3) In case, no template is specified, the standard web template is
   used   > transaction SPRO. In case, no web template is maintained as
   standard web template in transaction SPRO the standard web template
   delivered by SAP is used. It is recommended not to change
   the original SAP template but to create a copy, apply changes and
   maintain it as new standard web template in transaction SPRO. Please
   review note 643464 for further informations."

VARIABLE SCREEN SHOWN BY DEFAULT SCENARIOS:
===========================================
Only when there is a mandatory variable which is not filled and has
to be filled only by user via F4 help, then variable screen will
be shown automatically.

Thanks & Regards,

Sapna