Skip to Content
avatar image
Former Member

If Anybody knows BPC?, regarding performance. DB, EPM, etc.

The following activities were performed in the DEV and QA environment

1..Analysis and applied parameters of the note "1888485 - Database Parameter for 12.1.0.2" in the databases of BWD and BWQ. And the note:

1832231 - "500 Connection timed out Error" error in EPM Add-in).
2. We performed analysis and optimized performance and memory parameters in the BWD and BWQ systems.
3. Update missing statistics in BWQ were executed that had never been executed.
4. Database statistics were run.
and. Dictionary statistics were run.
5. System statistics were run.
6. Harmful statistics were deleted.
7. Oracle jobs were correctly scheduled in SAP DB13.
8. SAP housekeeping jobs were verified.

From the templates and calculations that BPC uses, we have noticed the following:

In calculations that last 10 minutes, it takes more than 1 hour and in calculations that last 1 hour, it takes more than 4 hours.

We have applied the option "Optimization of PCB Cubes"
We have applied a "Reorg" to the following BPC tables in the Development and Quality environments.

/ 1CPMB / WAM0EAD
/ 1CPMB / WATDIAD
/ 1CPMB / WADNJAD
RSBATCHDATA
REPOSRC
BALDAT
D010TAB

DOKCLU
SMIMCONT1
WBCROSSGT
ATAB
BAL_INDX
UJ0_STAT_DTL

We don´t know what else to do, Please your help.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 26, 2017 at 05:34 AM

    May be it's a good idea to provide BPC a BW version and SP...

    Add comment
    10|10000 characters needed characters exceeded