2228465 - Sort is not possible in AO if the measures have an hierarchical layout

If the measures are defined as an hierarchical layout (the measure has sub nodes) in Query Designer, sort is not possible in AO by drag and drop.

Definition in Query Designer:

Behaviour in AO:

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

• SAP Analysis for Microsoft Office 2.8

This is an intended behavior of Analysis Edition for Microsoft Office.

This behavior has been changed from AO 2.6. In AO 2.6 and afterwards version, sort is possible by drag and drop for hierarchical layout.

hierarchical, hierarchy, measure, measures, key figure, display, sort, not possible, change, position, Analysis for Excel, Analysis for Office, A4O , KBA , BI-RA-AO-XLA , Excel Addin , How To