T-code ST14 – all you ever wanted to know about your BW system

Today I ran into t-code ST14 which was very much of surprise to me. Actually the t-code provides all information about the BW system someone would ever be interested to know. Mostly all the information are from area of Data Volume Management (DVM) but they are very interesting I must emphasize. Normally one would need to dig into the system and use many reports, functions etc to collect all the information that the t-code provides. The t-code is called as Application Analysis tool.

The code itself is not only dedicated to BW systems. At introduction popup while t-code is started one can decide whether it shall be information about Basis, Security, CRM (if you run it on top of CRM system) and BW systems shown. In next I just focus on the BW option.

There are 4 main areas of the provided information:

·         Basis Information / Dataflow – info about many TOP 30 items like: Top 30 PSA analysis, ODS/DSO Objects (Active Data view), E or F -Fact or Dimension Tables, Aggregates, Master Data Tables, Other BW Tables, Other Tables, ODS/DSO Objects (Change Log view), ODS/DSO Objects (Total Size View), Cubes, Objects, InfoProviders with BWA index, HybridProviders (as of BW 7.30), Semantically Partitioned Objects (as of BW 7.3).

·         BW Evaluation / Customizing – info like follows: Total Size BW Objects, BW namespaces used in the system, Top 30 Cubes: result of SAP_INFOCUBE_DESIGNS, Top 30 Cubes: InfoCube Compression Rates, PSA: Age of Requests, PSA that contain REQU older than 4 months, Partitioning of E-fact tables, BW Archiving Objects, Upload from source systems (last 5 weeks), Overview InfoProviders, InfoProviders not loaded during last 4 months, InfoProviders with suspicious keywords in text, InfoProviders w/o suitable time characteristics

·         ABW Technical Processing Information – info about the tool itself, A – means application (analysis) for BW

·         HANA Tables – only in case the BW system is on HANA, info like Top 30 Tables within ROWSTORE

Additional areas of information:

·         Extended Checks

·         BW Planning

·         Standard Tables

·         BPC Analysis

·         HANA Feasibility Check

·         BPC Monitoring Statistics

In case you are curios how the data into the tool is gathered. Here’s an explanation. A background job can be scheduled within the code to collect all the information. The job has name e.g. BW APPLICATION ANALYSIS 0x (x in case it run in parallel). Depending on the BW system size runtime of the job may differ. Once you have a data all different types of analysis are possible as described above.

It is a great tool which saves a lot of time as all useful information can be found at one place.

Needless to say that t-code is part of “Service tools for Applications ST-A/PI” (see my other blog here). Also the functions behind the t-code can be leveraged by Solution Manager while the data from the t-code can be downloaded to the Sol Man and further reported and analyzed there.

More information:

Significance of ST14 SAP BW Performance improvement Tool