Skip to Content
0

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

Aug 25, 2017 at 06:21 PM

59

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin Aug 26, 2017 at 05:34 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded