how to find Webtemplates builld for a particular query ?.?.?.?.?.?.?.?.?.?

[Former Member]

Hi Gurus,

I wanted to find out what all are the web templates (in WAD) build/used for a partiuclar query in Query designer.

I tried "where-used" in BEx query designer, didn't work.

It's urget plz.

Regards,

Venkat

[Karol-K]

Hello,

Check the note:

1060384 Query Designer: Where Used List for Web Templates (BTMP)

This should help. There was an error for this function.

Regards, Karol

[former_member189638]

Go to RSA1 -> MetaData Repository.

There you can check in the Queries, you will get all the Web templates build on that Query.

Regards,

Rakesh

[Former Member]

Thanks a lot, that helped.

In this context, can you also please explain me: if the web template is the only link between the query we develop in BEX designer and the report displayed on Portal ?

Thanks,

Venkat

[former_member189638]

Yes, to my knowledge if you want to display the BEX Query in portal then you have to create a web Template. I don't think there is any other way to display a report in portal.

[Former Member]

where I get confused/unclear is the report that is displayed in Portal uses some default templates like 0ADHOC, 0ANALYSER etc... other than these when I try to compare my Webtemplate with the concerned report displayed in portal they don't completely match.

Wondering is there any other source (other than Web temp) for the portal report getting displayed ?

[majeed_mohammedabdul]

Hi Venkat,

The reason you are getting 0Analyzer and 0ADHOC is when we execute a query from query designer then the system takes the default web template specified in the system.

As for the Use of portal, when we create a iView for the Portal then we create a BW Query iView which in turn uses the default template again. So apart from the templates u design for the query these are the additional templates which comes up when u check the stats.

Hope It answers ur question

Thanks

Regards

Majeed

[Former Member]

Hi

Could I know that ur reports are a standard Queries??

There are different ways to publish in portal...like thru VC & Report Designer,VC is Visual Composer..to my knowledge.

U can chk in METADATA Repository as he said...U keep try

looking for ur Webtemplate for ur query.

Cheers

BI Learner.

[Former Member]

Hi,

You can set the properties of Web templates for all Web applications in Customizing.

You make these settings in the SAP Reference IMG > SAP Customizing Implementation Guide > SAP NetWeaver > Business Intelligence > Settings for Reporting and Analysis > BEx Web > Determine Settings for Web Templates.

Specifying standard Web templates for ad hoc analysis and reports

For more information, see the SAP Reference IMG > SAP Customizing Implementation Guide > SAP NetWeaver > Business Intelligence > Settings for Reporting and Analysis > BEx Web > Set Standard Web Templates

http://help.sap.com/saphelp_nw04/helpdata/en/9e/9f653ade969f4de10000000a114084/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/1f/37813b650cdc0be10000000a114084/content.htm

http://help.sap.com/saphelp_nw70/helpdata/en/23/fea042b443c56ae10000000a155106/content.htm

Regards.

[Former Member]

Thanks for your time but

sorry, didn't get the answer