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