Need Information on "Web Reporting in Portal"

[Former Member]

Hi Experts,

I want to gain more knowledge on the reporting side. Is there any reporting strategy that talks about Portal, web reporting and the Business Explorer. What is the best practice for reporting in NW 04's in most corporations? Is there any case studies? If someone can provide me with that info. will be a great help for me. Forum points are guranteed. Thanks

Padma K

[former_member563406 · Accepted solution]

Hi!

I dont think there is any official standard approach for this and it depends on the requirements of organization. Normally you create web templates using bex and then create iviews to integrate to portals. this is a very basic type of integration. alternatively u can do full scale integration , u can use the following<a href="http://help.sap.com/saphelp_nw04s/helpdata/en/a3/7b583c2439e66fe10000000a114084/content.htm">Help Link</a> to know more about it.

http://help.sap.com/saphelp_nw04s/helpdata/en/a3/7b583c2439e66fe10000000a114084/frameset.htm

regards

mohan

Message was edited by:

Mohan Krishna

[Former Member]

Hi,

1. Printing from Portal is very good. It converts to PDF from where U can take the printout.

2. It has very good Drag and drop facility

3.Graph and tables display are good.

4.Performace is very good in compare with Bex.

5.No frontend setting is required as compare to Bex.

6.Authrization can be controlled at R/3 as well as Poral level

Regards

Nilesh

[Former Member]

Hi Padma,

Most of the Organizations are moving towards web reports due to the following advantages:

1. The web query can be used without the GUI installed on the system. For Bex you need the SAP GUI installed.

2. As per SAP the web queries run faster than the bex query.

3. Bex uses excel which has a limitation of 65,536 rows where as your web query does not have that limitation.

4. The web query can be accessed from any browsing cafe also which is not the case with Bex Query.

Another important point is that you get EP(enterprise portal) by default installed with BI 7.0(ABAP+Java stack). So EP is used for publishing the web reports. The trend and the recommendation from SAP is to use EP for BI web reports. In most of the cases you would have a separate EP consultant apart from a BI consultant. The web report created by the BW consultant is published as an iview by an EP consultant.

BW with EP - Check these docs:

https://websmp101.sap-ag.de/~sapdownload/011000358700002894802003E/HowToBIPortal1.pdf

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/2482b090-0201-0010-d080-aec...

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/dc1d9990-0201-0010-16aa-db3...

Hope this helps.

Bye

Dinesh