Financial Management Blogs by Members
Dive into a treasure trove of SAP financial management wisdom shared by a vibrant community of bloggers. Submit a blog post of your own to share knowledge.
cancel
Showing results for 
Search instead for 
Did you mean: 
former_member181999
Contributor
2,046


  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:
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



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)

Labels in this area