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