SAP Knowledge Base Article - Preview

2477489 - BPC Lite Optimize Performance Issue

Symptom

  • Your data base version is DB2 10.5 FP5
  • BPC Lite optimization is taking over 30 hours to complete
  • ST12 trace shows most of the time is spent in ABAP statement DD04L
  • ST12 shows a select statement that uses the SAPTOOLS.MEMORY_TABLE 


Read more...

Environment

  • SAP Business planning and consolidation 10, version for SAP NetWeaver (BPC NW 10);
  • SAP Business planning and consolidation 10.1, version for SAP NetWeaver (BPC NW 10.1);

Product

SAP Business Planning and Consolidation 10.0, version for SAP NetWeaver ; SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver

Keywords

DB2, DB6, Lite optimization, IBMid, DD04L, "DD04L", SQL, SQL Statement, Select Distinct, SELECT DISTINCT, TABLE, SAPTOOLS.MEMORY_TABLE, CAST, AS BLOB,  CARDINALITY , KBA , performance , troubleshooting , 3rd party tools config and system admin , EPM-BPC-NW , NetWeaver Version , BW-SYS-DB-DB6 , BW DB2 Universal Database , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.