Friday, October 31, 2008

SAP BI web reporting URLs

Usually end users are using SAP Portals (Enterprise Portal) or any other portal for accessing BI queries. You as a support consultant trying to solve incidents within queries often do not have a portal access therefore you need to access it via raw links or you use TA RSRT (Query monitor) in BI backend system to simulate query there. When user issue is linked with we reporting TA RSRT is not enough and most convenient way is to run query/query view/web template from via web browser. In order to obtain URLs it is good to start with TA RTST. In all versions of this TA you can choose a way how query data is displayed: LIST – classic raw ABAP report layout, BEx Analyzer – MS Excel layout and HTML – web reporting layout. In case you opt for HTML and execute some report, you can afterwards get a URL for this report. 



This functionality allows you to get this URL and run query or other query via URL easily.



If you ran your NetWeaver BI system on both AS stacks: ABAP and JAVA you have a web reporting in 2 favors:
ABAP web and JAVA web



URLs are different for those 2 stacks:


ABAP:

Query:
http://machine:port/SAP/BW/BEX?INFOCUBE=put_infoprovider_here&QUERY=put_query_name_here

Web template:
http://machine:port/SAP/BW/BEX?INFOCUBE=put_infoprovider_here&TEMPLATE_ID=put_your_web_tmpl_here

BEx "Report Designer" report:
ABAP Stack seems to be is not supporting "Report Designer's" report as following URL doesn't work for me:
http://machine:port/SAP/BW/BEX?INFOCUBE=put_infoprovider_here&REPORT=report_name_created_in_BEx_ReportDesigner


Broadcaster:


JAVA:
General format of URL:

<PORTAL_PROTOCOL>://<PORTAL_SERVER>:<PORTAL_PORT> /<bi_launcher>?<param>=<value>

e.g. http(s)://machine:port/irj/servlet/prt/portal/prtroot/pcd!3aportal_content!2fcom.sap.pct!2fplatform_add_ons!2fcom.sap.ip.bi!2fiViews!2fcom.sap.ip.bi.bex?QUERY=put_query_name_here

Query:
param = QUERY

Web template:
param = TEMPLATE_ID

Query view in workbook:
param = QUERY_VIEW

Query view:
param = SOURCE_VIEW

Enterprise report (BEx "Report Designer" report:): 
param = REPORT

Workbook:
param = WBID

XCELSIUS DASHBOARD
param = DASHBOARD

Bookmark:
param = BOOKMARK_ID

Link to JAVA Portal, where you can choose query:

http(s)://machine:port/irj/servlet/prt/portal/prtroot/pcd!3aportal_content!2fcom.sap.pct!2fplatform_add_ons!2fcom.sap.ip.bi!
2fiViews!2fcom.sap.ip.bi.bex

- update 27.02.2017 - 
more JAVA stack related parameters added

- update 16.12.2015 - 
See post related to "ABAP web reporting URL parameters" as well.

Link to documentation:

2 comments:

João said...

Do you know if I can insert additional variables in the URLs?

Can I change the result area display size? it's too small.

Martin Maruskin said...

hi Joao,
as far as I know it is not possible.
cheers