Skip to Content
author's profile photo Former Member
Former Member

Publishing queries in the Portal

Hi experts

I have a requirement for having queries publishe din the portal

I know I can do it by creating web template, but it time consuming

I've tried the following:

1) on query designer I published query to the portal. Issue is that selection criteria of my query will only pop up on the portal if there is some mandatory value. Do you know any workarround for this

2) I also see that by default all my reports are in the portal.. But I have the same issue stated above... no selection criteria will pop up when exectuting those, except if there is any mandatory criteria~

Can anyone help with this portal issue? Any tip is highly appreciated

Many Thanks

Joana

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Feb 08, 2012 at 04:14 PM

    By default BEx Web is using web template 0ANALYSIS_PATTERN which is set to not display variable screen by default. typically we copy the template to a new customized version. You can then set the variable screen to dsplay by default and make any other chnages you need. Then use config(RSCUSTV27) to set the new customized template as your default template for Adhoc analysis. You will have to restart BI JAVA for the change to take effect.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 01, 2012 at 10:16 AM

    Hi,

    If you dont want variable screen then you need set the Web template parameter "Display Variable Screen" to "Turn OFF".

    Then varibale screen should not appear while opening up the web template.

    I will explain How variable screen will work:

    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,

    Venkat

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Venkat

      >

      > I'm a little confused by your reply...

      >

      > Is this applicable to when you wnat to use web templates but also when you just publish it form the Bex query designer?

      >

      > I basically want to go with the less time consuming option, as i'm facing a lot of time issues...

      >

      > I see that the queries are already in the portal without no action from my part (i assume is something by default).. or i can publish them to portal in bex query designer (relatively quick)

      >

      > My issue is, that on both of this options, I have no selection criteria working in portal (and i need it) - only when I have mandatory fields..

      >

      > So, in order to have it, what should i do? The steps you've indicated? How would i apply this to the case where queries are already in portal (by default)?

      >

      > Many thanks

      > Joana

      I am not sure if there's a workaround, until you can make the variables optional in BEx Query Designer & publish them.

  • Posted on Feb 09, 2012 at 12:58 PM

    Hi Joana

    I assume what you want is for the variable selection to pop up always.

    In that case, why not make one of the variable mandatory in the already existing queries? This should solve you problem within less time.

    Regards,

    Joe

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.