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

Using Query View in a Web Template

Hi all,

Let's say that I open up a query in the BEx Analyzer and do some modifications to the cells and then save it as a query view. Next time when I open up my saved query view, can I see the modified view or will I see the original query view again?

Thanks,

Satyajit.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 22, 2005 at 10:20 PM

    The template will reopen to the default view. Though, as of BW 3.5, you can add a “Query View Selection” web item to the template to allow the selection of saved query views. If you are using a version of BW prior to 3.5, then you must use custom coding techniques to access the views. I hope this helps.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2005 at 09:44 PM

    Hi Satyajit,

    Put the web item "Query View Selection" in your web template. This will allow you to save a query view and view it in your web template later, making a sort of cockpit. This item can be used itself to save local views, e.g. just for the individual user.

    Be warned, this web item has a lot of idiosyncracies to it and you will probably need to review some OSS notes before you are done. But it has some very nice features.

    Cheers,

    Doug

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Doug, Excellent advice. One other note I thought I would share is that the Query View Selection Web Item behaved very erratically for use when placed in a template with more than one rendering web item. To get around this behavior:

      • Create a blank web template

      • Save to web template to create the TEMPLATE_ID OBJECT

      • Insert the CL_RSR_WWW_ITEM_VIEW_DROP_DOWN into the template

      • Configure the web item target and parms

      • Switch to Text only mode

      • Remove the Data Source Object tag if it exists. The final should have only two Object Tag sets, SET_PROPERTIES for TEMPLATE_ID, and the CL_RSR_WWW_ITEM_VIEW_DROP_DOWN object

      • Use the template include object, CL_RSR_WWW_ITEM_TEMPLATE, to reference your new web template

      • Make sure the Data provider names in the new template matches the data provider name in the parent document

      • That fixed the issue for us!

      Examples for the above explanation:

      View Select Tags:

      <object>

      <param name="OWNER" value="SAP_BW"/>

      <param name="CMD" value="GET_ITEM"/>

      <param name="NAME" value="ITEMVIEWDROPDOWN_1"/>

      <param name="ITEM_CLASS" value="CL_RSR_WWW_ITEM_VIEW_DROP_DOWN"/>

      <param name="DATA_PROVIDER" value="DP1"/>

      <param name="VIEW_DD_TARGET_ITEM" value="GR1Table"/>

      <param name="VIEW_DD_SHOW_BUTTONS" value="X"/>

      <param name="VIEW_DD_USE_ALL_QUERY_VIEWS" value="X"/>

      ITEM: ITEMVIEWDROPDOWN_1

      </object>

      Insert of a new template

      <object>

      <param name="OWNER" value="SAP_BW"/>

      <param name="CMD" value="GET_ITEM"/>

      <param name="NAME" value="MYVIEW1"/>

      <param name="ITEM_CLASS" value="CL_RSR_WWW_ITEM_TEMPLATE"/>

      <param name="TEMPLATE_ID" value="ZMY_VIEW_SELECT"/>

      <param name="GENERATE_CAPTION" value=""/>

      ITEM: MYVIEW1

      </object>

      Hope this helps,

      Joel

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.