Solution : https://service.sap.com/sap/support/notes/1591837 (SAP Service marketplace login required)
Summary :
When analyzing unexpected query results in SAP, using RSRT (Query Monitor) and LISTCUBE for comparing InfoProvider data proves invaluable. RSRT enables detailed examination and debugging, facilitating the identification of discrepancies in key figure calculations and data retrieval. Additionally, LISTCUBE offers a direct comparison between query results and the physical data in the cube, ensuring data consistency. Users should use RSRT to dissect query features and run queries in safe mode to minimize error sources. The note outlines effective strategies to simplify queries, understand used OLAP features, and compare data, aimed at enhancing diagnostic accuracy and operational efficiency in SAP environments.
Key words :
40 % ckf1 2 'kf' / 'rkf1' 2 kf 1000 pc kf 1000 pc rkf1 500 pc kf 500 pc ckf2 5 'kf' / 'rkf1' 5 kf 1000 pc kf 1000 pc rkf 200 pc kf 200 pcfor, 'kf' / 'rkf1' 2 kf 1000 pc rkf1 500 pcmeans, drilldown characteristics0country cha 1 include = atdynamic filtermaterial cha 3 include, serial mode---------------------------------------------------------------------multiprovider explain -> note 489135---------------------------------------------------------------------display sql query -> check, ] key figure definition[iii] query simplification[iv] comparing query result, ckf2ckf1 = kf / rkf1ckf2 = kf / rkf2kf, cache -> exclude inconsistent cache entries---------------------------------------------------------------------display statistic data ->, infoobject iobjnm 0amountinfoobject infoobjecttype selectiontype +/-sign operator, 2010selection 0003material cha 1 include = t09these filter restrictions, /saphelp_nw73/helpdata/en/a0/2a183d30805c59e10000000a114084/frameset
Related Notes :
| 1717880 | Virtual Key Figures & Characteristics |
| 1681396 | Query Performance |
| 1592982 | VC: Query selections not passed to virtual cube |
| 1548125 | Interesting facts about Inventory Cubes |
| 1485729 | Unposted values |
| 1479893 | BW LISTCUBE improvements |
| 1240163 | Amount too high by factor of 100 for HUF, JPY currencies |
| 1151957 | Interesting facts about the OLAP Processor/Analytic Engine |
| 1125883 | Simplified example query for analyzing problems |
| 891029 | RSR00002: Virtual chars and key figures in reporting |
| 834996 | Probleme mit der Eigenschaft 'Konstante Selektion' |
| 729459 | Unexpected number |
| 489135 | MultiCube/MultiProvider "Explain" via RSRT |
| 442987 | Decimal places/rounding units of measure |
| 351827 | Incorrect data with multiple selection? |