SAP Knowledge Base Article - Preview

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

Symptom

  • 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).


Read more...

Environment

  • 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

Product

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

Keywords

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 , troubleshooting , kill process , increase in reports and templates , light , 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 , hanamdx , 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 , EPM-BPC-NW , NetWeaver Version , BW-BEX-OT , OLAP Technology , BW-PLA-BPC , BPC 'embedded model' , BI-RA-AO-BPC , BusinessProcessFlow, Workstatus and BPC for AO , BI-RA-AO-XLA , Excel Addin , EPM-XLS , EPM Excel Client , FIN-RTC , Real-Time Consolidation , HAN-DB-EPM , SAP HANA Planning and Simulation Platform , LOD-ANA-PL , Planning , 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.