SAP Knowledge Base Article - Public

2485534 - "Compact Display in Rows" or "Compact Display in Columns" are Disabled for HANA view

Symptom

In Analysis for Office, after insert a HANA view as a data source or open a workbook which contains HANA views as data source, you want to use action "Compact Display in Rows" or "Compact Display in Columns" but the "Hierarchy" button is displayed as below:

  • The "Hierarchy" button is available, but action "Compact Display in Rows" and "Compact Display in Columns" are grayed out.

            Compact.png

Environment

  • SAP BusinessObjects Analysis for Microsoft Office 2.X

Reproducing the Issue

In Analysis for Office, insert a HANA view as a data source or open a workbook which contains HANA views as data source.

Cause

Action "Compact Display in Rows" and  "Compact Display in Columns" are always disabled for HANA views because it is not supported.

Resolution

"Compact Display in Rows" and "Compact Display in Columns" are not supported for HANA views.

Keywords

AO, ribbon, grey out, limitation , KBA , BI-RA-AO-XLA , Excel Addin , How To

Product

SAP Analysis for Microsoft Office 2.6 ; SAP Analysis for Microsoft Office 2.7 ; SAP Analysis for Microsoft Office 2.8 ; SAP BusinessObjects Analysis 2.4, edition for Microsoft Office ; SAP BusinessObjects Analysis for Microsoft Office 2.5