SAP Knowledge Base Article - Preview

2272366 - Performance Analysis Tools For SAP BPC/BW Reporting


  • The knowledge base article (KBA) guide focuses on performance issues observed in reporting and other processes when using SAP Business Planning and Consolidation, version for SAP NetWeaver (BPC / EPM-BPC-NW), or BW reports.
  • This guide provides some simple steps to help identify where performance issues may lie and help to report your issue to the correct support team at SAP (DB, BW, BPC).



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


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


Input Schedule, Report, light Optimize, light optimization, full optimization, lite optimization, lite optimize, ERRORS FOUND RETRIEVING DATA, cube being locked. ST12, Clear Metadata Cache, fiddler , SQL optimization, Table Index analysis, DB statistics/Table/SQL/IO, SAP_INFOCUBE_DESIGNS, Share Memory, BPC_QUERY_CACHE, Buffer Sizing, RSRCACHE, BW Cache. runtime statistic, Query Aggregates, Database Cache, Parallel Query,MDX, EPM addin report size limitation, trace, Diagnostics, DB02, ENABLE_SHARED_OBJECT, consume, RSRT, Get_mdx_data, Performance Statistics, RSDRI, UJSTAT , SLG1, RSTT, UJHANA_MDX_TEST, UJHANAMDX, MDXTEST, index, Parallel Execution,  parallel framework, OLAP Cache,  long runtime, RFC_METADATA_GET, RFC, AO, query runtime,Analysis Office,RFC metadata, CL_RSR_CACHE_STORAGE_DB,wait time, long running program, STAD, ST03/ST03N, /SDF/MON, DPMON, Wait for work process, Response time,CL_UJAM_HIER_ACTIVE_CACHE,MAX_ACTIVE_HIER_SHM,time dependent, hierarchy,HANA Trace , KBA , hanamdx , light , increase in reports and templates , input schedule , tools , mdx , mdxtest , performance , lite optimization , report , light optimize , full optimization , analysis , best practices , lite optimize , light optimization , query , st12 , sm21 , sql communication trace , troubleshooting , take too long time , bpc_query_cache , bpc 10 , clear metadata cache , db statistics/table/sql/io , bw cache , sql optimization , bpc 10.1 , table index analysis , sap_infocube_designs , rsrcache , buffer sizing , clear cache , hang , parallel query , long refresh time , bpc slow , slow , runtime statistic , query aggregates , query performance and memory consumption , sap business planning and consolidation , not responding , database cache , bottleneck , kill process , long running time , data manager slow , share memory , longer time , EPM-BPC-NW , NetWeaver Version , BW-BEX-OT , OLAP Technology , BW-PLA-BPC , BPC 'embedded model' , HAN-DB , SAP HANA Database , EPM-XLS , EPM Excel Client , BI-RA-AO-XLA , Excel Addin , BI-RA-AO-BPC , BusinessProcessFlow, Workstatus and BPC for AO , FIN-RTC , Real-Time Consolidation , How To

About this page

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

Search for additional results

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