During "Set Prompt", getting error message "A valid string is required" while selecting "Period/Year" value from BEX query.
SAP Analytics Cloud 2018.16.4
Reproducing the Issue
- Create a Model using Data Acquisition from SAP BW.
- Choose the query.
- Deselect ‘Show Mandatory Only’.
- Select Period/Year and try selecting any value.
- Notice this error.
Currently this is a limitation in SAP Analytics Cloud
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.
2686792 - Data Acquisition fails with internal server error when importing data from BW BEx query with mandatory variables in SAP Analytics Cloud (SAC)
SAP BW, Live, Import, BEX, failing, not working, does not work, format, data , KBA , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , Problem