Solution : https://service.sap.com/sap/support/notes/1151957 (SAP Service marketplace login required)
Summary :
SAP Note clarifies issues with Calculated Key Figures (CKFs) and formulas that display unexpected results. Key points include misinterpretations due to incorrect result row values, improper handling of 'Calculate Results as...' in formula calculations, and faulty exception aggregations. Understanding the OLAP processor basics, namely, process steps and the sequence of calculation and aggregation, is crucial. Use of outdated methods like 'Calculate before Aggregation' leads to performance loss and data inconsistency. SAP advises utilizing Exception Aggregation properly for accurate data analysis, ensuring that further calculations consider exception-adjusted values, and avoiding obsolete settings which might not integrate well with newer enhancements.
Key words :
/saphelp_nw70/helpdata/en/9d/76563cc368b60fe10000000a114084/frameset, /saphelp_nw70/helpdata/en/17/82853c2dc5c505e10000000a11405a/frameset, sap delivers special demo content, formula variables / replacementpath variable vi, remarks key figure definition, feature 'define exception cells', button called 'technical information', interpret query results correctly, called nested exception aggregation, function 'key figure definition'
Related Notes :
| 1591837 | How to analyze query results |
| 1475193 | Warnings in transaction RSRT -> Technical Info |
| 1385580 | How does a formula variable with a replacement path work? |
| 1257455 | Exception aggregation: Performance and memory requirement |
| 1133936 | SAP DemoContent for features: Transaction RSFC |
| 1005772 | Formula variables with replacement from key |
| 853058 | Calculate Results/Single Values as ... priority rules |
| 729459 | Unexpected number |
| 717951 | Calculate single values as ... in hierarchy lists |
| 379832 | Calculating w/ variables w/ subst. from attrib. w/o char. |
| 310791 | Key figures with exception aggregation LAST |