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 , increase in reports and templates , light , input schedule , full optimization , report , light optimization , analysis , best practices , tools , mdxtest , light optimize , lite optimization , lite optimize , query , mdx , st12 , performance , sm21 , sql communication trace , troubleshooting , take too long time , bpc 10 , clear cache , db statistics/table/sql/io , sap_infocube_designs , bw cache , query performance and memory consumption , parallel query , bpc_query_cache , bpc 10.1 , bpc slow , sap business planning and consolidation , rsrcache , share memory , hang , runtime statistic , buffer sizing , query aggregates , clear metadata cache , kill process , longer time , bottleneck , slow , table index analysis , database cache , sql optimization , not responding , data manager slow , long refresh time , long running 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.