SAP Knowledge Base Article - Public

2691332 - Edit Member Order option is missing for Accounts/Measures in SAP Analytics Cloud

Symptom

  • The "Edit Member Order" option is missing for the Account / Measure dimension in SAP Analytics Cloud (SAC).
  • It is not possible to sort the account column or row order of the table / grid in a Story.

Environment

  • SAP Analytics Cloud 2018.16

Reproducing the Issue

  1. Logon to SAP Analytics Cloud (SAC).
  2. Open the affected SAC Story which has a table.
  3. Click Edit.
  4. Select the table.
  5. Click the Builder.
  6. Note the Account dimension.
  7. Click the '...' button.
  8. Observe that there is no option to 'Edit Member Order'

Cause

  • Product limitation

Resolution

There is no confirmed delivery date.

Workaround: 

  1. Mark the first account you want to show. Create empty columns after it.
  2. Refer /link in each of the columns to the column you want to appear in a specific order (frontend calculation).
  3. Create thresholds on that columns (If needed).
  4. Hide the columns you referred to which are in the wrong order.

See Also

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

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, accounts, How can I change the order of my columns in a table structure in a SAC story, Sorting in the  reporting, Sorting of the Accounts delivers the Structure as needed in the reporting, Order of accounts for Orca models, However there is still a need to re-order measure siblings as desired, I should also be able to mix the sort of story created calculated measures with the account dimension measures. , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0