SAP Note 751577 - APD-FAQ: Data source query

Component : Analysis Process Designer -

Solution : https://service.sap.com/sap/support/notes/751577 (SAP Service marketplace login required)

Summary :
SAP Note addresses performance and data accuracy issues during analysis processes when querying data source nodes. It discusses scenarios such as long runtimes, memory overflows, incorrect data, and specific error messages like CX_RSAN_SVC_CHECK_ANALYSIS_N=>NODE_FIELDNAME_NOT_UNQIUE. Key aspects include optimizing OLAP processors, utilizing "InfoProvider" data sources for mass data handling, and effective partitioning techniques. Enhanced partitioning settings should be carefully adjusted, considering characteristics and package sizes, to manage memory efficiently and control query execution times. Notes 1237933, 1137302, and 1137583 provide additional insights related to memory consumption considerations in BW 7.0.

Key words :
cust  country  customer group     article  article group  quantity salesc0001, program terminations incorrect data error message cx_rsan_svc_check_analysis_n=>node_fieldname_not_unqiue, analysis process -> olap bapi -> ole db, system issues error message rsan_wb 010, system issues error message b1 888, experience problems evaluating condensed properties, composite sap notes covering restrictions, error message b1 887 refers, c1          a00001  a1            400   1200c0001, c1          a00002  a1            220   4200c0001

Related Notes :

1237933MDX:More memory released when BAPI_MDPROVIDER_REFRESH called
1224318MDX: InfoProvider restriction for the member rowset
1137583MDX: High memory consumption for complex statements
1137302RSCRM: Memory usage optimization
1127381APD: Data missing during partitioning w/ parallel processing
1047255APD: High consumption of main memory despite partitioning
1032937APD: Partitioning with compound characteristic
958231APD: All key figures in query result have the value 0
914782APD: Incorrect partitioning of the query
818834Composite SAP note for BI Content 3.3 Add-On Patch 17
794257APD.FAQ: General performance note
792671APD - Query as data source - incorrect data
605213RSCRM: Performance
605208RSCRM - Restrictions