Sunday, June 10, 2012

Story on DTP's log entries as of BW 7.3 SP03

It is very popular and of course very reasonable among BW developers to add custom messages to monitor table of DTP. Adding those you can easily indicate what went wrong during the load or just point out an warning to support person who monitor the loading. I’m explaining how particular message can be added into the monitor in this post.

DTPs are having limitations. I proved my self about this e.g. in case of limitation of DTP filter or ABAP dumps. After I did one upgrade project to version 7.3 I found another limitation of DTPs. This time it is related to no of messages that can be posted into monitor. I’ve seen customer transformations having complex logic and storing a lot of monitoring records. Those records we re later on analyzed and based on e.g. no of particular error or warning different action was to be triggered. We had there more that 10.000 monitoring entries. Such a DTP ran fine in BW version 7.0 but not anymore in 7.3. Whiel analyzing this issue I found following 3 SAP notes:

Status about monitoring entries in DTP’s monitor in BW 7.3 SP03+ is following:

You can store up to 9.900 monitoring entries. However system defaults no of entries to 9.000 for each data package.  Means if system reached no of messages 9.000 there are only messages type of error added. If system added another 1.000 error messages; so no of 9.901 is reached system dumps (MESSAGE_TYPE_X in the Method ADD_MESSAGE of the class CL_RSBM_LOG_DTP_DP). However to obey limit of 9.000 you need to customize how many of entries are allowed for DTP. You need to customize this in table RSBKADMIN. Put your value no greater than 9900 into field MESS_NO_9000 of this table. If you want to force system to add also warning or information messages into the log after it hits 9.000 entries you need to customize this as well in table RSBKADMIN. You need to put values like AEXW (A-abort, E-error, X-exit, W-warning) into field MESS_TYPES_9000.

Suite of helpful BW programs – BW Tools (ST13->BW-TOOLS)

I do not remember when was it for 1st time when I found this tool mentioned in SDN’s forums. I think it was related to process chains analyses. This tool covers analyses of process chains run time as well. 

Basically tool is indented to be used predominantly by SAP Active Global Support Team to support performance analysis in the areas of BW-IP (Integrated planning); BW reporting etc. Customers are free to use this tool too (according PPT attachment to note 1035990). Don’t be surprised if TA ST13 is not present in your system. The thing is that tool is coming with ST-A/PI component (Service Tools for Applications Plug-In). ST-A/PI component is so called Service Software Framework used to handle so called SAP EarlyWatch/GoingLive sessions. I was blogging about those sessions before here and here

Depending on version of ST-A/PI that you have deployed in your BW system selection screen of TA ST13 may look like:

From this screen kindly observe that those are BW tools available in ST13. More details about particular tools are here:

BIIPTOOLS - BI-IP Performance Toolset This tool has following components:

Planning Activities Overview – TOP x: planning sequence/functions/buffers executed.

BW Statistics Analysis – Provides a list of activities done in system related to BW-IP

FOX Analysis – Analyses FOX codes; recommendations to tune FOX coding

Characteristic Distribution - to analyze how data is distributed in cube’s fact tables

Technical Query Settings – Similar to TA RSRT, difference is that you can check multiple queries

BW Performance Benchmark – As planning functions cannot be distributed to several CPUs of your server this helps to decide either CPU should be upgraded

Prefill OLAP Cache for planning sequence – For OLAP cache pre-filling with required selections of characteristics, done by report ZBPPOIP

BPSTOOLS - BW-BPS Performance Toolset Similar set of reports just for BPS based planning

BW-TOOLS - BW Tools This was very first part of ST13 that I discovered a long time ago. It has advanced Process Chain monitoring (several chains in one view with its status, run time, end date/time, drill down to RSPC1,...)

BWATOOLS - BWA Support Tools This is sol called BWA Support Toolkit where you can analyze various standpoint related to your BWA status. See (note 1517326, introducing blog)

BWQUAC_CUST - BW Query Alert Collector Customizing, used for in the Solution Manager Business Process Monitoring.

BW_QUERY_ACCESSES - BW: aggregate/InfoCube accesses of queries Not sure what is purpose of this. I was not able to find any data in this tool.

BW_QUERY_USAGE - BW: query usage statistics Not sure what is purpose of this. I was not able to find any data in this tool.

Update 02/05/2016 for particular tool: the data is read from BI Statistics 3.x table RSDDSTAT which is obsolete in NW 7.x based BW systems. Therefore this tool is not providing any data. 

Update on 10/05/2015:

In case tool names are not visible in the popup selection of tcode ST13 you may follow up as described in following post: Uncommenting reports /SSA/* - Service tools for Applications ST-A/PI

Update on 07/12/2016:

ABAP program which is behind t-code ST13 -> BW Tools is /SSA/BWT

Used sources: