BW Query in Portal

[Former Member]

hi all,

I have a query.When this query is displayed through Portal we get the toolbar at the top for graph,downloading to excel,csv,exceptions,conditions.

Our requirement is that when we display the query this toolbar should not be visible.I have approached it through Web Application Designer that is creating template.It is working fine. But problem is there are many queries and for each query i will have to make corresponding templates.

Now my question is , is there any other way by which we can achieve this?

Any suggestion would be greatly appreciated.

Thanks in advance.

regards,

Yogesh

[Former Member · Accepted solution]

I'm not sure how you're referencing the web report from the portal, but if you are using a URL you can define a generic web template and then change the query/view within the url.

The URL syntax to specify the default web template is...

/sap/bw/BEx?sap-language=EN&bsplanguage=EN&cmd=ldoc&TEMPLATE_ID=MYTEMPLATE

If you want the generic web template to refer to a query include the following in the url...

&CMD_1_RESET_DATA_PROVIDER&INFOCUBE=MYCUBE&QUERY=MYQUERY

If you want the generic web template to refer to a saved view include the following in the url...

&CMD_1_RESET_DATA_PROVIDER&DATA_PROVIDER_ID=MYSAVEDVIEW

Hope this helps,

David.

[Former Member]

Thank you all for your help.

it was really useful.

regards,

Yogesh

[Former Member]

Hi,

this is the default Web Template.

See

http://help.sap.com/saphelp_nw04/helpdata/en/f9/7f12403dbedd5fe10000000a155106/frameset.htm (BW 3.5)

http://help.sap.com/saphelp_bw33/helpdata/en/45/685b3ebd564644e10000000a114084/frameset.htm (BW 3.0/BW 3.1)

for setting a new Default Web Template in spro.

Heike