Skip to Content
  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

1.JPG

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:
   1.  UJ0_STAT_HDR
    2. UJ0_STAT_DTL

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

Table-1: UJ0_STAT_HDR

2.JPG

Table-2: UJ0_STAT_DTL

3.JPG

4. Procedure to delete

Trx: SE38

SAP Standard Program name: UJ0_STATISTICS_DELETE

5.JPG

6_.JPG

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.

1_1.JPG

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)

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply