on 11-22-2005 10:04 PM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.