SAP Knowledge Base Article - Public

2708723 - Getting error message "A valid string is required" while selecting "Period/Year" value from BEX query in SAP Analytics Cloud

Symptom

  • During "Set Prompt", getting error message "A valid string is required"  while selecting "Period/Year" value from BEX query.

Environment

  • SAP Analytics Cloud 2018.16.4

Reproducing the Issue

  1. Create a Model using Data Acquisition from SAP BW. 
  2. Choose the query.
  3. Deselect ‘Show Mandatory Only’.
  4. Select Period/Year and try selecting any value.
  5. Notice this error.

Cause

  • Currently this is a limitation in SAP Analytics Cloud

Resolution

Workaround:

  • During "Set Prompts", please only make selections on other variables which are mandatory variables. And then clicking on Next while leaving "Period/Year" blank. This can bypass the issue and get to "Build SAP BW Query" prompt and then create the model.
  • This functionality might be available only with the Live Data Connection via 3rd-Party providers.

See Also

2686792 - Data Acquisition fails with internal server error when importing data from BW BEx query with mandatory variables in SAP Analytics Cloud (SAC)

 

Keywords

SAP BW, Live, Import, BEX, failing, not working, does not work, format, data , KBA , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , Problem

Product

SAP Analytics Cloud 1.0