SAP Knowledge Base Article - Preview

3123311 - Analysis for Office displays duplicated rows/columns when executing a query that contains hierarchy with inner-nodes

Symptom

When executing a BEx query that contains a hierarchy, by default, you see that the inner-nodes for each node are displayed in AO, as per screen shot below:

These duplicated records can be in rows or in columns (because it depends on setting "Expand") and the required is to hide these inner nodes from AO interface.

“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 Analysis for Microsoft Office
  • SAP Analysis for Microsoft Office, edition for SAP Analytics Cloud

Product

SAP Analysis for Microsoft Office all versions ; SAP Analysis for Microsoft Office, edition for SAP Analytics Cloud all versions

Keywords

hierarchy, duplicated lines, duplicated columns, nodes, properties, display, inner-nodes, leaves, Consolidation Unit , KBA , BI-RA-AO-XLA , Excel Addin , Problem

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.