cancel
Showing results for 
Search instead for 
Did you mean: 

Accessing a GUI interface to develop Reports just as in Cognos

Former Member
0 Kudos

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.

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

hi Amanda,

if you are in bw 3.5 onward, try bex web analyzer ?

you can call with the template with

http://[your bw server:port]/sap/bw/BEx?sap-language=EN&bsplanguage=EN&CMD=LDOC&TEMPLATE_ID=0ANALYZERhttp://help.sap.com/saphelp_nw04/helpdata/en/0d/af12403dbedd5fe10000000a155106/frameset.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/0d/af12403dbedd5fe10000000a155106/frameset.htm

hope this helps.

Former Member
0 Kudos

Great, I accessed your second link and just completed reading it: Very helpful.

On the quote

“The BEx Web Analyzer provides you with a standalone, comfortable Web application for data analysis that you can call using an URL or as an iView in the Enterprise Portal”

1.

What is “an iView in the Enterprise Portal” Is iView a client I need to install? If so why the phrase “in the Enterprise Portal”?

2.

In your link: http://[your bw server:port]/sap/bw/BEx?sap-language=EN&bsplanguage=EN&CMD=LDOC&TEMPLATE_ID=0ANALYZER

does it mean that if I make the appropriate substitution for the server, it will open a browser-based BEx (i.e. BEx Web Analyzer)?

i.e. suppose the IP of the server is 170.170.50.40 and port number is 1100, you saying that if I run from the browser:

http://170.248.54.76:1100/sap/bw/BEx?saplanguage=EN&bsplanguage=EN&CMD=LDOC&TEMPLATE_ID=0ANALYZER

the BEx Web Analyzer should come up?

By the way, from the SAP Logon on my desktop, I could see the server name as an IP address but from the properties, I see could NOT see the port number? Is there a default port # I can try with? Or, is there a command to tell the port number for the application?

3.

From the review of link, I found this comment in line with that but please confirm: “ Web template 0ANALYZER forms the basis of the BEx Web Analyzer”

If so, are there other templates other than 0ANALYZER and what are their functions?

Thanks.

0 Kudos

hi Amanda,

1. no, you have no need to install other component.

you can call with URL.

2. yes, you are right. you can try without port number,

normally we won't need port number.

3. there is other template in nw2004s, but i never try.

hope this helps.

Former Member
0 Kudos

Hi,

unfortunately, I am still not able to access it through the Web although I have access to it through my desktop.

What do you think might be going on?

Thanks.

nikhil_chowdhary2
Contributor
0 Kudos

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:

http://help.sap.com/saphelp_bw33/helpdata/en/a9/71563c3f65b318e10000000a114084/content.htm

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

http://help.sap.com/saphelp_bw33/helpdata/en/97/54593c8948c54fe10000000a114084/content.htm

Hope it helps,

Regards,

Nikhil

Answers (0)