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:

Tuesday, October 28, 2008

Resetting buffers: TAs $*


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 within SAP GUI.



/$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


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

Monday, October 27, 2008

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.

Sunday, October 26, 2008

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




Saturday, October 25, 2008

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 3rd 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.



Sunday, October 5, 2008

TA RSRT, RSRT1, RSRT2 difference?


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. 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

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 :-)

Saturday, October 4, 2008

SAP system behavior while debugging


In one of my previous posts I stated several possibilities how to start ABAP debugger tool. Here comes some debugging specialties discussed.
Debugging is often activity of skilled users or key users and I don’t know a lot of consultants who can avoid usage of debugging as well. Several possibilities are in place: remote debugging; tRFC/ /qRFC/bgRFC debugging; HTTP/external debugging etc. Normally we debug while logged in SAP GUI in SAP system. Basically you can switch processing of any transaction or report to debug mode via entering /h code to transaction field of SAP GUI. There are some other possibilities how to enter debug mode for e.g. job – this is possible via TA SM37 -> menu Job -> “Capture: active job” etc. SAP system based on NetWeaver ABAP stack application server has special functionality dedicated to debugging. A work process which is processing your task is set into a DEBUG mode. Debugging in general does requesting a huge memory consumption and system resources as well. This means that system is moving data to its extended memory in PRIV mode. In this mode normal request being processed by other work processes are located in local memory instead of extended. Extended memory is occupied by data for debugging user exclusively. However this cannot persist in system for a long time. So since you are not active in debugging session for some time system is canceling whole debugging with following messages:

Transaction from "PRIV" session reset after timeout (Message no. 14048)

Transaction from "DEBUG" mode (after timeout) reset (Message no. 14056)

From basis point of view for production system there should not be a necessity to adjust profile parameters in order to allow debugging for a long time and for a so much users. If you wish to avoid this message anyway or you want to make debugging more comfortable on development or test system you need to consider following profile parameters:
  • rdisp/max_priv_time # Standard value: 600
  • rdisp/wppriv_max_no # Standard value: MAX(1, Anzahl Dialog-WPs)
  • rdisp/max_debug_lazy_time # Standard value: 600

Other very common obstacle is that there is not debugging possible at the moment; you can experience it while a system is issuing message like:

You cannot debug ABAP programs at this time

While there are a few more users doing debugging in system other than you; you can experience following message:

Max. number of debugging mode users reached (Message no. 14111)

In this case you need to check out entry in table T000-CCATEGORY. This field is describing a role of client that you are logged in. If there is a value of P it is a production system/client. In such a clients number of work processes that can change to debug mode is limited to half of the DIALOG processes in system. Therefore setup number of dialog processes accordingly.
If system is running out of memory and it cannot allocate enough memory for data processes in your transaction you may get message like:

Memory low. Leave the transaction before taking a break!

From user’s point of view you really need to at least restart transaction or better to log off and on to system. Basis team would need to re-setup a dialog timeout and/or work process timeout of profile parameters, memory parameters, increase physical of machine, etc.
BTW: Notice that ABAP debugger is completely written in C programming language and not in ABAP. On other world of JAVA stack – in NetWeaver Developer Studio debugging is completely different but this is another story…

Starting up ABAP debugger

Starting up ABAP debugger

There are following different option of starting ABAP debugger via transaction field of SAP GUI:

  • "/h"              a very common way, it start ABAP and classic dynpro debugging

  • "/hs"             starts ABAP, system and dynpro debugging

  • "/ha"            starts ABAP Debugging only

  • "/hx"            end of debugging

  • "/hmusa"       creates memory snapshot

  • jdbg              in TA SM37 restart of a finished or crashed background job for debugging

  • /ron              start ABAP Runtime Analysis measurement (transaction SE30)

  • /roff              stop ABAP Runtime Analysis measurement (transaction SE30)

Other posts on ABAP debugger topic: