SAP Knowledge Base Article - Preview

2588571 - Query performance with GROUP BY GROUPING WITH SUBTOTAL option

Symptom

  • The performance of query with the statement like GROUP BY GROUPING and WITH SUBTOTAL on the calculation view is bad.
  • In the Planviz, a lot of time consumed at "JERequestedAttributes" and "Network Data Transfer".
  • The memory usage is high.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


Read more...

Environment

  • SAP HANA Platform 1.0
  • SAP HANA Platform 2.0

Product

SAP HANA 1.0, platform edition

Keywords

GROUPINGSETS, WITH SUBTOTAL, GROUP BY, calculation engine, calculation view, performance, AO, Analysis Office, BO , KBA , HAN-DB-ENG , SAP HANA DB Engines , Problem

About this page

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

Search for additional results

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