SAP Knowledge Base Article - Preview

3525965 - BW Hierarchies used in BW Queries: Design Considerations effecting the Query Runtime and Memory Consumption

Symptom

A BW query using presentation hierarchies needs more time than expected and/or requires significant high memory on the ABAP application server. It even may run into a timeout or memory dump.


Read more...

Environment

  • SAP BW/4HANA - All versions
  • SAP NetWeaver Systems based on Hana Database

Product

SAP BW/4HANA all versions ; SAP Business Warehouse all versions

Keywords

hiera_aggra, performance, long query runtime, memory dump, TSV_TNEW_OCCURS_NO_ROLL_MEMORY, TSV_NEW_PAGE_ALLOC_FAILED, STORAGE_PARAMETERS_WRONG_SET , KBA , BW-BEX-OT-OLAP , Analyzing Data , BW-BEX-OT-OLAP-HIER , Using Hierarchies , BW4-AE-CORE-HIER , Hierarchies (Runtime) , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.