SAP Note 1142664 - MDX: Composite SAP note about performance improvements

Composant : MDX,OLAP-BAPI,OLE DB for OLAP - OLE DB Provider

Solution : https://service.sap.com/sap/support/notes/1142664 (Connexion à SAP Service Marketplace requise)

Mots Clés :
rscrm_bapi apd reason, recent support package, long runtime, mdx statement, related notes, corrections produced, mdx interface, notes mentioned, individual corrections, performance problems

Notes associées :

1639514MDX: Long runtime even though an empty set is queried
1638551MDX: Lange Laufzeit bei Verwendung des Hierarchize
1637792MDX: Long runtime in the method FIND_BEST_INSTANCE
1611618MDX: Runtime of functions INSTR & UCASE
1610004MDX: Long runtime in the method GET_MULTIPLE_STRINGS
1607491MDX: Long runtime for MDX function INSTR
1604027MDX: Long runtime when you use a calculated member
1596989MDX: Long runtime in method CHECK_IF
1596255MDX: Long runtime in the method IS_AUTHORIZED
1574984MDX: Too many characteristic structure elements are read
1573815MDX: Long runtime on the database for COUNT (*)
1554272MDX: Long runtime if crossjoin is used
1553927MDX: High memory consumption; crossjoin, intersect, generate
1530858MDX: Runtimes are long when the member rowset is determined
1511745MDX:Default measure&numerous members in a set- runtime prob.
1507653MDX: High memory consumption/runtime error during EXCEPT
1489375MDX: High memory consumption with Descendants / Leaves
1481568MDX: YTD, calculated members and many dimensions
1479836MDX: Generate - Too many hierarchy levels are read
1454543MDX: Optimized data query for IIF statement
1450366MDX: High memory consumption with Intersect(), Crossjoin()
1448691MDX: Performance of set
1448445MDX: Performance improvement of EXCEPT() function
1446437MDX:Increased memory consumption for op in calculated member
1437074MDX: Optimization of IIF statement for property values
1430427MDX: Increased memory consumption for calculated members
1426394MDX:Increased memory consumption with YTD calculated members
1425854MDX:Increased memory consumption w/ calculated member tuple
1410242MDX: Performance of LAG() and LEAD()functions
1398382MDX: Performance optimization of the filter function
1395307MDX: Retrieving axis data takes an extremely long time
1392631MDX: Subsequent correction to Note 1383354
1392193MDX: Subsequent correction for 1390371: Sorting is too slow
1390371MDX: Sorting is very slow
1390065MDX: Accelerating bXML
1383593MDX: Improving the performance of some MDX functions
1383354MDX: Very long runtime -- too many KIDs read
1381821Memory and Performance Analysis for MDX
1368202MDX optimization: Reading minimal set of key figures
1338760MDX: Performance of function EXCEPT(<d>.Members, <d>.[All])
1333559MDX: Performance of DESCENDANTS (..., LEAVES) function
1322798MDX: Enhanced performance for basXML-based flattening
1316004MDX: Performance of INTERSECT() function
1312912MDX: Optimized usage of constants
1310048MDX: Optimized processing of the IIF statement
1283099MDX: Performance of the UNION() function
1281603OLE DB for OLAP: Performance when determining cube rowsets
1273477MDX: Performance improvements during determination of axes
1272334MDX: Performance improvement enhanced for basXML API
1241650MDX: API for flattening access based on basXML
1240165Performance optimization for hierarchy authorizations
1237933MDX:More memory released when BAPI_MDPROVIDER_REFRESH called
1235882MDX: Optimizing the determination of dimension members
1235608MDX: Optimized memory consumption for flattening access
1230712MDX: Implementing the unorder function
1230303MDX: Buffering of hierarchy metadata
1170323MDX: Performance when filtering on hierarchy node
1169205MDX: Filter transfer in the case of cross join
1162416OLE DB for OLAP: Restriction on MEMBER_CAPTION
1162349OLE DB for OLAP: Restriction on text and performance
1161911OLE DB for OLAP: Many read accesses to table RSRREPDIR
1161234MDX: Performance of EXCEPT() function
1086509MDX: Too many key figures/measures requested
1016067Improving performance for MDX and DataStore object
838800Composite SAP Note for consulting notes about MDX/OLAP BAPIs