2588571 - Query performance with GROUP BY GROUPING WITH SUBTOTAL option | SAP Knowledge Base Article

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 also high.


Read more...

Environment

HANA 1.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.