SAP Knowledge Base Article - Public

3104566 - When trying to sort members of a column from Model connecting to BW Live connection, the 'Edit Member Order...' button is grayed out

Symptom

  • When trying to sort members of a column from Model connecting to BW Live connection, the 'Edit Member Order...' button is grayed out.
  • When hover over the mouse on 'Edit Member Order' button, "member sorting is not supported for BW measures with hierarchies".

Environment

  • SAP Analytics Cloud (SAC) 2021.14 (2021 QRC03)

Reproducing the Issue

  1. Open a story with table component.
  2. In Designer, click the three dot button of the measure object.
  3. Edit Member Order button is grayed out.
  4. When hover over the mouse on Edit Member Order button, "member sorting is not supported for BW measures with hierarchies".

Cause

"Key Figure Hierarchy" is used in BEx query, the structure is not flat, the structure is like the parents hierarchy having children. This is the reason why the Edit Member Order is not to be applied.

Resolution

Change the structure of measure in BEx query to flat design.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Analytics for Cloud,BEx query, BEx view, cube, info provider, restricted measure, key figure, BEx, parent-child, hierarchy , KBA , LOD-ANA-LDC-BW , SAC Live Data Connection BW , Problem

Product

SAP Analytics Cloud 1.0