Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Accessing a GUI interface to develop Reports just as in Cognos

I just worked on a project in Cognos and there was this flexibility in working within a browser instead of the in Excel as in BW. What is the equivalent of “BEX”, which is used in developing queries/report in the Web environment such as the browser based tools like ReportNEt and Query Analyzer in Cognos?

Basically I am looking for a GUI to work with, if one exists, then how do I access it?

If brief, can you give me a few steps on how to gains access to say, a BW Cube and prepare a report based on that through a browser, just as you will do in BEx.


Former Member replied

Hi Amanda,

In order to use these features you need to have the web services configured on your system. Get your basis person to configure the HTTP service on the BW server. Also a default template can be set in BW IMG which will be used whenever you execute any query on the web.

There are many templates which SAP has provided for different purposes. For adhoc query designing using a web based environment you can use the 0ANALYZER. For display of queries in a web environment you might want to try 0ADHOC.

Through the Web Application Designer you can design your own templates in a GUI based environment. Its very powerful if you have some knowledge of HTML & Javascript.

Go through this section for WAD:

To design queries through a Web based GUI you need to include the adhoc query designer item to your template:

Hope it helps,



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question