SAP Knowledge Base Article - Public

2973425 - Existing Filter and custom order disappeared after changing variable value in SAC story

Symptom

Existing Filter and custom order disappeared after changing variable value in SAC story.

Environment

  • SAP Analytics Cloud 2020.14.20
  • S/4HANA On-premise Live Connection

Reproducing the Issue

  1. Establish a “S/4 HANA – Direct” connection.
  2. Create a new live model based on standard query.
  3. Don’t change anything under “All Dimensions” or “Measures” and save the model.
  4. Create a new responsive story.
  5. Insert a grid.
  6. When prompted, select enter the mandatory variables.
  7. Create a calculated measure. i.e. Movement: that sums debits and credit in global currency
  8. Rename these standard measures to “Opening” and “Closing”
  9. Edit Member Order of the Measures so that the Opening Balance is first, Movement is second and Closing Balance is third.
  10. Open Account, activate a hierarchy and filter on any nodes.
  11. Custom sort works fine and hierarchy object works as filter.
  12. Open the prompt and change the variables value.
    >> a.     The filter disappeared.

              b.     The initial measure member order changes also disappeared.

Cause

The issue is under investigation by development team currently.

Resolution

 The issue is under investigation by development team currently.

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, sort, order, filter, missing, s4hana, live, limit, restriction. , KBA , LOD-ANA-LDC , SAC Live Data Connection , Problem

Product

SAP Analytics Cloud 1.0