Solution : https://service.sap.com/sap/support/notes/1257455 (SAP Service marketplace login required)
Summary :
When executing queries with exception aggregation in SAP NetWeaver BI 7.0, users may encounter long response times or memory bottlenecks. This issue is due to the expanded functionality for calculated key figures which now allows aggregation referencing multiple characteristics, increasing data granularity and volume processed by the OLAP analyzer. For instance, using a high-instance reference characteristic like 0BPARTNER significantly increases data load, potentially exceeding the 2 GB memory limit of the analytic engine, leading to errors such as TSV_NEW_PAGE_ALLOC_FAILED. Remedies include redesigning queries to reduce data volume, using BEx Broadcaster for pre-filtering, employing Analysis Process Designer for partitioned data processing, or transforming data via InfoProviders to handle complex aggregations efficiently.
Key words :
/saphelp_nw70/helpdata/en/d2/02223c5f00612be10000000a11402f/frameset, /saphelp_nw70/helpdata/en/64/c674402a71d162e10000000a155106/frameset, query designadd additional filters, >> invisible drilldown characteristics solution, long response times, sap netweaver bi 7, error messages mentioned, call transaction rsrt, related notes listed, sap netweaver bi
Related Notes :
| 1600314 | Performance-Optimierung bei Formelausnahmeaggregation |
| 1228378 | Problems w/ formula exception aggregation in NetWeaver 2004s |
| 1151957 | Interesting facts about the OLAP Processor/Analytic Engine |
| 1137994 | Re-optimizing a query |
| 1136163 | The query settings in RSRT -> Attributes |
| 779123 | Memory-related terminations at runtime |
| 425207 | SAP memory management, current parameter ranges |
| 379832 | Calculating w/ variables w/ subst. from attrib. w/o char. |
| 192658 | Setting parameters for BW systems |
| 152638 | Aggregation settings in calculated key figures |
| 146289 | Parameter Recommendations for 64-Bit SAP Kernel |