2272366 - Performance Analysis Tools for SAP BPC NetWeaver/BW Reporting

• This article guide is to assist users in identifying and addressing 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 the performance issues may be occurring and help to report your issue to the appropriate SAP support team at SAP (DB, BW, BPC).

Read more...

• 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 11.0, version for SAP BW/4HANA 1.0
• SAP Business Planning and Consolidation 11.1, version for SAP BW/4HANA 2.0
• SAP Business Planning and Consolidation 2021, version for SAP BW/4HANA 2021

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 11.0, version for SAP BW/4HANA ; SAP Business Planning and Consolidation 11.1, version for SAP BW/4HANA

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,RSPMREQUEST, RSPM, RSAPOADM, BW Planning API, , KBA , hanamdx , increase in reports and templates , light , mdx , best practices , full optimization , analysis , input schedule , light optimize , mdxtest , performance , report , light optimization , tools , st12 , query , lite optimization , lite optimize , sql communication trace , sm21 , table index analysis , buffer sizing , bpc 10.1 , bpc 10 , database cache , clear metadata cache , bw cache , query aggregates , sql optimization , bpc_query_cache , sap business planning and consolidation , clear cache , parallel query , db statistics/table/sql/io , sap_infocube_designs , share memory , take too long time , longer time , not responding , rsrcache , long refresh time , bottleneck , query performance and memory consumption , runtime statistic , slow , data manager slow , bpc slow , long running time , hang , troubleshooting , kill process , EPM-BPC-NW , NetWeaver Version , BW-BEX-OT , OLAP Technology , LOD-ANA-PL , Planning , BW-PLA-BPC , BPC 'embedded model' , BI-RA-AO-BPC , Please use component BI-RA-AO-XLA , BI-RA-AO-XLA , Excel Addin , EPM-XLS , EPM Excel Client , BW4-DM-RSPM , Request Status and Process Management , FIN-RTC , Real-Time Consolidation , BW-WHM-DST-RSPM , BW Request Status and Process Management , HAN-DB-EPM , SAP HANA Planning and Simulation Platform , How To