Skip to Content
Author's profile photo Ashok Babu Kumili

Enhancement (SAP BPC) to Enable Business Process & Improve Data Load Performance. (Part-2)

  1. Problem Statement:
    BPC model has the data feed from various systems on hourly and as per the needs hourly multiple times. It is observed that the performance of the BPC model is reduced.
  2. Root Cause:
    In a basic analysis of admin activities carried out in the model. It is identified that the housekeeping activates and statistics monitory are not being put in place.

Current architecture


3. Solution:
For Business Planning and Consolidation SAP has given the performance tuning techniques which are very simple & easy to use. Here is a best practice to clear few system related tables and enable the Models run faster. To the application maintenance team it is advised to keep this process as a monthly/weekly activity (As per the need).

Target tables to clear:

Total records identified in the below 2 tables are 12+ Million. in the Production system.

Table-1: UJ0_STAT_HDR


Table-2: UJ0_STAT_DTL


4. Procedure to delete

Trx: SE38

SAP Standard Program name: UJ0_STATISTICS_DELETE



5. Procedure to set model parameters

As a process we can also set the model to not to store the statistics data.  Use transaction code “UJ0_IMG_03” To set the model parameter “BPC_STATISTICS” to ON/OFF.


6. Achievements:
1.BPC data loading(Data Manager) is improved by 20%
2.Refresh time of the Reports on the BPC model is improved by 20%

Note: We are also doing Light optimization on weekly basis. We want to an extra mile in performance improvement so we have followed above detailed solution in multiple projects (ECC <–>BW<–>BPC<–>Legacy Systems)

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.