Database/Disk Space Analysis of BW System

[former_member197660]

Purpose:

To have an overview of data volume in order to check and control the growth of data in BW system.

An report to serve following purpose:

• Analytical & flexible report to check periodic growth of data
• To check the components contributing the the growth
• Report for periodic house keeping activity & migration projects
• Alert report in case disk space consumption has reached a defined limit

In all previous version of BW this data was available in several transactions like DB02, ST03, in some underlying tables like :DB6TREORG etc and via API's.

However with SAP-7.3 release the technical content was enhanced for such analysis by providing the option to load this data into BW data models in conventional manner to facilitate flexible/multidimensional view of mentioned data.

Solution/Realization:

To use the new technical content the BW system has to be on SAP7.3 environment and install latest BI content version.

Following are the BI content activation steps required to activate the relevant data stream:

Step 1: Log in to BW system and Trnx: RSA1 -> BI Content tab

Step 2: Maintain the following settings:

               Source system Assignment : Local BW system (Myself BW system)

               Collection Mode                  : Automatically

               Grouping                            : In data flow before & afterwards.

Step 3: Expand the Multiprovider section from Object type panel and select/double click the option: "Select Objects"

Step 4: On the new small window select the binocular search button and type in : 0TCT_MC25 as displayed in following image:

Step 5: After selecting the mentioned row select the button "Transfer selections" from left bottom of the window

Step 6: Then select the Multiprovider and its subsequent objects and select the "Install" button as displayed:

Step 7: This will install all the objects required for data loading to the infocube and the reports on top of multiprovider

Step 8: Make a init data load for the infocube: 0TCT_C25. Please note the following relevant objects for the data flow:

            Multiprovider  : 0TCT_MC25

            Infocube        : 0TCT_C25

            Datasource    : 0TCT_DS25 (The data source is delta enabled)

Step 9: Automate the data load in process chain to load data on a periodic manner to store the history.

Output/Reports:

Technical content provides wide range of flexible reporting on the data, few of them are following:

1) 0TCT_MC25_Q0103: BI Objects Size Overview  :- This report provides an overview of data in various table space in BW system. like following example:

   

2) 0TCT_MC25_Q0105 : BW DB Usage: Monthly Overview : This report provides an overview about the growth of data in BW system. like following:

   

3) 0TCT_MC25_Q0205 : BI Data Distribution By Table Types : This report provides an overview of data based on table types in the system as :

  

Technical content too provides rich set of characteristics to analyze the statistical data from various aspects like : Data allocation based on Infoareas, Application Component, Top 10 tables in system.

Automation/Alert:

These reports can be scheduled over broadcaster and sent to desired user groups in order to have consistent periodic overview of the system growth.

Exception alerts can be set on the queries which would be broadcasted when the disk space consumption has reached certain defined limits.