Solution : https://service.sap.com/sap/support/notes/1381821 (SAP Service marketplace login required)
Summary :
SAP Note addresses memory and performance issues experienced when accessing SAP BW via the MDX interface, outlining symptoms such as long-running SQL, unusual SQLs, unapplied filters, excessive dimensions, and timeouts. It provides an introduction to MDX OLAP processing and common issues, recommending a review of system parameters and existing SAP coding optimizations. The note details the MDX processor's operations, impacts of requested data volume, and common pitfalls in query and data management. Solutions like adjusting Web Intelligence query setups and keeping database statistics current are advised to prevent performance degradations and system crashes.
Key words :
form select_4 gp4gla2ni8ytyggczraij0h6icw form select_2 gp4gla2ni8ytyggczraij0h6icw form select_1 gp4gla2ni8ytyggczraij0h6icw form select_0 gp4gla2ni8ytyggczraij0h6icw form olap_back sapsrrk0 form fill_sp_1 sapsrrk0b2 olap processor, form sx_to_bdata saplrrk0 form setxx_fuellen_02 saplrrk0 form setxx_fuellen_0 saplrrk0 form setxx_fuellen saplrrk0 function rrk_data_get saplrrk0b3 mdx processortask, cl_rsdm_read_master_data======cp cl_rsdm_read_master_data=>_fill_txt_n cl_rsr_mdx_crossjoin_multi=>empty cl_rsr_mdx_crossjoin_mulit=>non_emptyc common issues, -odb ole db provider priority recommendations / additional info category, member rowset/ mdx axis constructionyou experience long runtimes, menu entry mdx command ' set debug flags, /saphelp_nw70ehp1/helpdata/en/a0/2a183d30805c59e10000000a114084/frameset, customer component bw-bex-ot-mdx mdx, coding indicators/typical error call stack, mdx - olap processing layersthe mdx processor formulates
Related Notes :
| 1681396 | Query Performance |
| 1530858 | MDX: Runtimes are long when the member rowset is determined |
| 1272044 | Analyzing MDX problems |
| 1232751 | MDX: Result contains too many cells (more than 1 million) |
| 1224318 | MDX: InfoProvider restriction for the member rowset |
| 1142664 | MDX: Composite SAP note about performance improvements |
| 971164 | Performance of RRT_GET_DIM_CARDINALITY |
| 838800 | Composite SAP Note for consulting notes about MDX/OLAP BAPIs |
| 820925 | MDX - Restrictions |