cancel
Showing results for 
Search instead for 
Did you mean: 

Using Query View in a Web Template

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Former Member
0 Kudos

Hi Joel,

Thanks for the reply. Well I'm using BW 7.0.3. So is there a way by which I can modify the results of a query, save it and later use it?

Thanks,

Satyajit.

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

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