SAP Knowledge Base Article - Public

3623306 - Some members can't be found using Search Help in Data Analyzer or Stories with S4 HANA/BW Live connection

Symptom

Searching in the Value help in Data Analyzer or Stories does not show all proper results or shows the empty list while there should be values

Environment

SAP Analytic Cloud;

BW/S4 HANA live connection;

Reproducing the Issue

  1. Open a Story or Insight that is created based on BW Live connection.
  2. Open Prompt.
  3. For a Dimension -> Select member -> Select "ID" and enter an 'XXX" to search ->No member is found.
  4. Check from the dimension from BW or S4 HANA backend, the member do exist.

Cause

Two possible causes:

  1. This is caused by a bug with BW.
  2. You have a customer exit implemented for CONVERSION_EXIT_MATN1_OUTPUT/INPUT, but the similar logic is not implemented for CONVERSION_EXIT_MATN1_RANGE_I, which causes the conversion problems between internal format and external format. 

Resolution

For root cause 1, apply the Note 3305924 - Value help: Too few values for characteristic with conversion exit MATN1.

For root cause 2, please adjust the customer exit logic to make sure the conversions are aligned.

Keywords

KBA , LOD-ANA-DAN , SAC Data Analyzer , BW-BEX-OT-ODP , Query Runtime for Operational Data Provisioning , LOD-ANA-LDC-BW , SAC Live Data Connection BW , Problem

Product

SAP Analytics Cloud 1.0