SAP Knowledge Base Article - Public

3459646 - Search function in story filter could not work as expected when the dimension contains thousands of members in a live BW Optimized Story in SAP Analytics Cloud (SAC)

Symptom

  • Create a story based on live data connection to BW/4HANA system and enable the Optimized Design Experience mode for this story
  • Create a story filter based on the dimension containing thousands of members and try searching dimension members in this story filter
  • Make sure the Display Option of these dimension members in story filter has been chosen as "Description" or "Description and ID"
  • Observe that no search result would appear in this story filter

Environment

  • SAP Analytics Cloud 2024.2.18

Reproducing the Issue

  1. Log on to SAC
  2. Create a story based on the live data connection to BW/4HANA system and enable the Optimized Design Experience mode for this story
  3. Add a story filter based on a dimension containing thousands of members
  4. Make sure the Display Option of these dimension members in story filter has been chosen as "Description" or "Description and ID"
  5. Click on the story filter to open the dimension list and try searching any dimension member in this story filter
    => Observe that no search result would return and no dimension member could be searched out in this story filter

Cause

  • This is caused by the outdated BW/4HANA system version

Resolution

  • Update SAP BW/4HANA system to at least SAP BW/4HANA 2.0 SP0 (for non-hierarchical dimensions) and at least SAP BW/4HANA 2.0 SP4 (for hierarchical dimensions) per SAP Note 2715030 - Considerations when using SAP BW and SAP S/4HANA Live Connections in SAC (https://me.sap.com/notes/2715030).

See Also

Your feedback is important to help us improve our knowledge base

Keywords

sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, Story, story, Stories, stories, Story 2.0, story 2.0, Optimized Design Experience mode, ODE, ode, Optimized View mode, OVM, ovm, story filter, search, BW/4HANA 1.0, huge number, input control , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0