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:

http://machine:port/SAP/BW/BEx?CMD=START_BROADCASTER70

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:

Help.sap.com

1490646 - How to call 3.x ABAP Run-Time from BEx Query Designer 7.x

Resetting buffers: t-codes $*

 There is a pair of SAP transactions which might be used when you need to reset data from SAP database tables temporarily stored in buffers. Actually, those codes are not real transactions but so called OK fields that are able to be entered in field of transaction (sometimes called as command field) within SAP GUI. The below codes manipulates with different buffers of the application server.

 

 

/$TAB RSADMIN    refreshes buffers for specific tables e.g. RSADMIN

/$TAB                    refreshes all table buffers + the program buffer

 

/$SYNC                  refreshes all table buffers, except the program buffer

/$SYNP                  probably the same as above

 

/$CUA                    refreshes a CUA (central user administration) buffers

 

/$DYN                    refreshes a screen buffers

/$DYNP                 probably the same as above

 

/$NAM                   refreshes a nametab buffers

 

/$OTR                    refreshes a OTR (Online Text Repository - central storage location for texts and its translations) buffers

                             

 

After successful execution of those transactions you are suppose to get messages like:

 

All buffers were reset

Message no. 00012

 

TAB buffer reset

Message no. 00044

 

More information:

Starting up ABAP debugger

Not very known transaction codes for lists

SAP into Teradata acquisition?

It is been a while a rumor is spreading over web regarding SAP is willing into Teradata acquisition. SAP would strengthen it data warehousing products portfolio where have a big share others pure data warehousing companies like SAS. Over last year’s acquisition war with IBM, when SAP got Business Objects and IBM got Cognos it seems that that it strikes back. Teradata is currently very proud to be independed as its spin off from NCR Corp in October 2007. Of course they would to stay as they are – independed. On other hand SAP has recently announced big freeze that would possibly mean share holder of SAP do not want to spend any additional money in today’s financials crisis but they can be on opposite side as the current markets very low rates and it might worth to invest in acquisition.

Teradata is well known for its massively parallel processing system. It has its own database system (DBMS). It is very fast and very suitable for very large size of databases. Formerly they had a hardware portfolio of products as well. Still they offering they brand of disk arrays. They invited so called AMP Access Module Processor – a common discrete chunks distributed evenly among the database in order to read it very fast. Before AMP was hardware; now it is a software component.

Let see what future will bring and how data warehousing companies compete between each other, how ORACLE, SAP, IBM, TERADATA, SAS, SYBASE etc.

-         update on 16/05/2009 –

It is been one and half a year since I wrote this post and things are getting closer. Recently (around end of April) SAP and Teradata announced agreement to provide SAP NetWeaver BW+ on the Teradata environment (database). In terms of this integration SAP BI portfolio including BW and BusinessObjects software will be co operable with Teradata Active Enterprise Data Warehouse solutions. SAP BW will be running natively on Teradata database platform. By this agreement we can assume that SAP’s intent to acquire Teradata is over or it is just another step to get into it.

See here on what else SAP is cooperating with Teradata.

-      update on 13/09/2022 – 

After more than decade it turned out that, there wasn’t any acquisition at all. Instead, quite a battle took place. In 2018 Teradata accused SAP of trade secret misappropriation, copyright infringement and antitrust violations. Plaintiff claimed that since 2009 the two companies were working together on a joint venture (called Bridge Project) that had an aim to combine SAP’s ERP capabilities and data warehousing capabilities of Teradata. Soon after SAP introduced HANA database in 2011 it cut its ties to Teradata.  By that, they suggested that SAP might have used trade secrets to develop its own database.

Later in 2018, US court ordered Teradata to be more specific how SAP misappropriated trade secret. SAP argued to dismiss the case having said that if Teradata was really concerned, they should have investigated as soon as HANA was launched not just eight years after. However, the court rejected SAP's motion.

In 2021 the US court found that one of SAP's patents (from 2004) is not sufficiently innovative to a merit the legal protection of a patent. There was also the founding that Teradata's technical trade secret claims fail because it failed to protect the confidentiality of its information. So no clear winner at this time.

TAs RSPC*

Process chain functionality of SAP BI is very important from application maintenance point if view. It does automate data loading furthermore it visualizes, controls and monitor loads. Within SAP BI SAP NetWeaver 7.0 (former NW 2004s) there is a set of RSPC* transactions dedicated to process chains as follows:

 

RSPC Process Chain Maintenance, basic transaction

RSPC1 Process Chain Display, Displaying one PChain only

 

RSPC1_NOLOG Process Chain Maintenance, Log displaying of one PChain only

RSPC2 Process Chain via Process, Displays process types available for PChains

 

RSPCM Monitor daily process chains

RSPCP Process Log, Display of log for a process

 

RSPC_RESTART        Restart Process Chain Run

Activating scripting in SAP GUI

In order to use scripting within SAP GUI you need to activate several settings. First one is on level of your SAP application server by instance profile parameter:

sapgui/user_scripting = TRUE

This parameter is set to false by default. You can do this modification via TA RZ11. Afterward make sure you have set scripting as enabled in your SAP GUI settings; menu “Customize local layout (ALT+F12)” -> Options -> tab strip: Scripting -> check “Enable scripting”:

 

For system notification of running scripts, set up in your SAP Configuration window in Windows Control panel ->“Notify when script attaches to running GUI”:

To enable GuiXT functionality: SAP GUI settings; menu “Customize local layout (ALT+F12)” ->“Activate GuiXT”:

 

Few interesting facts about SAP as company

 

Despite today’s not very optimistic times caused by financial crises worldwide and recent SAP’s announcement about behaving very costly efficient – means Big Freeze I would like to share some interesting facts about SAP. Basically SAP is world’s largest business application software company and 3^rd largest independent software provider globally and…

Basis facts: //as of Jan-Jun 2008

• 96.400+ installation of SAP software
• 75.000+ companies run SAP
• 51.602 SAP employees:
• According regions:
• EMEA: 26.563
• APAC: 11.143
• NAFTA: 13.896
• According functional areas:
• Software & Services: 6.651
• Professional services: 14.057
• R&D: 15.148
• Sales & Marketing: 10.815
• G & A: 3.367
• Infrastructure: 1.564
• Nationalities represented worldwide: 100
• Nationalities represented at Walldorf: 88
• Top 5 nationalities at Walldorf office: German, British, American, Indian, Russian
• Average age: 37
• Percentage of employee over 50: 5%
• Average length of company affiliation: 5.3 years
• Attrition rate: 1.8%
• Percentage of women: 30%
• Percentage of female people managers: 18%
• Org. structure:
• Office of the co-CEOs: H.KAGERMANN, L. APOTHEKER Bill McDermott and Jim Hagemann Snabe (as of 7th of Feb 2010)
• Research & Breakthrough Innovation: P. ZENCKE
• Products: no designated person as of S.AGASSI departure
• Production:  C. HEINRICH
• Global Service &  Support: G. OSWALD
• Customer Solutions & Operations (CSO): L. APOTHEKER
• Finance & Administration: W. BRANDT (CFO)
• Human Resources & Processes: C. HEINRICH
• 12 million users in 120+ countries
• 1.600+ Partners
• 180.000 SAP partner certificates
• 10.000 developers within SAP company
• 10 international SAP Labs (Development Sites):
• EMEA: Germany (Walldorf), France (Sophia Antipolis), Bulgaria (Sofia, Hungary (Budapest), Israel (Ra’anana)
• APAC: India (Bangalore), Japan (Tokyo), China (Shanghai)
• NAFTA: USA (Palo Alto), Canada (Montreal)

Furthermore I would not forget mention few words about SAP culture. Within SAP internal there is no exact dress code introduced; it is expected that everybody is dressed mannerly. Formal dress expected within business meetings with customers and for consulting people on-site location of course. SAP is well know for employing people with strong academic backgrounds like PHDs and professors to strengthen their R&D. SAP is famous for its patents as well.

-      Update 02/13/2010 – SAP is returning to co-CEO model as Apotheker stepped down as CEO. Co-CEOs are now Bill McDermott and Jim Hagemann Snabe. See details here.

- Update 07/22/2013 - Return  back to 1 CEO structure. In May 2014 Bill McDermott will be lifted to sole CEO position while Jim Hagemann Snabe will step down as co-CEO and will serve in supervisory board.

- Update 05/04/2014 - Dr. Vishal Sikka member of SAP executive board left SAP for personal reasons. He will be replaced by Robert Enslin and Bernd Leukert in the executive board. In addition Leukert will be leading SAP global development organization.

- Update 07/07/2014 - Due to driving its global effort SAP changed its  legal form to a European Company (Societas Europaea, SE) from AG.

TA RSRT, RSRT1, RSRT2 difference?

Update on 10.9.2019

Query Monitor is very useful tool used to analyzing problems with BI queries. You can very quickly find out how healthy your queries are and so on. Tool is accessible with transaction RSRT but there are 2 more transactions: RSRT1 and RSRT2. Difference between RSRT and RSRT1 is that via RSRT1 you can run Query views as well. What differentiate RSRT2 against two others is not clear to me. Only visible difference is that in RSRT2 it is possible to create/get variant (see corresponding buttons). Somebody got an idea?

RSRT:


RSRT1:


RSRT2:

To complete this post I’m adding some more TAs related to Query Monitor:

RSRT Start of the report monitor

RSRT1 Start of the Report Monitor

RSRT2 Start of the Report Monitor

RSRTQ BWT: Query Definition (check of query definition)

RSRTRACE Set trace configuration

RSRTRACETEST Trace tool configuration
MDXTEST MDX Test Panel
MDXTEST_OLD MDX Test Panel
RSFLAT Flat MDX
RSTT_EXECUTE_TRACE - t-code doesn't exits anymore

RSTT_EXCECUTE_TRACE- t-code doesn't exits anymore, perhaps it was deleted as there is a typo error in its name, however last 2 t-codes are still present in source code of BW programs

Read more on thsi topic in 2nd part of this article:
TA RSRT, RSRT1, RSRT2 differences? (Part 2)

ST05 – SAP trace, what seconds?

Why you trying to figure out what database access takes too much time; you can you transaction ST05 called Performance Analyses tool. On Display Trace screen there is information about runtime of the individual SQL statements in microseconds. Since this is not mentioned nowhere in this transaction it may lead to doubts in what seconds is this information stored. So do not get confused it is in microseconds.

BTW: 1 microsecond = 1.0 × 10E-6 seconds :-)