SAP Knowledge Base Article - Preview

3710966 - Error when using the search engine on dimension filter - SAP Analytics Cloud BW Live Model

Symptom

Error in SAP Analytic Cloud Story build with a BW Live model when using the search engine for filtering on the dimension.

  • Filtering works when selecting an element from the displayed list but fails when using the search engine with any ID.
  • Error messages observed:

    "Unable to initialize query"
    "Query can't be executed without setting values for all mandatory variables"

  • It also generates an ABAP Dump on transaction ST22:
Category               ABAP programming error                                                       
Runtime Errors         CONVT_NO_NUMBER                                                              
ABAP Program           CL_RSMDS_DIMENSION============CP                                             
Application Component  BC-BW-SRV

Short Text: "*" cannot be interpreted as a number
What happened?: Error in the ABAP application program.
The current ABAP program "CL_RSMDS_DIMENSION============CP" had to be terminated because it found a statement that could not be executed.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."


Read more...

Environment

  • SAP Analytics Cloud
  • SAP BW4/HANA
  • SAP BW4/HANA Cloud
  • SAP NetWeaver

Product

SAP Analytics Cloud all versions ; SAP BW/4HANA Cloud all versions ; SAP BW/4HANA all versions ; SAP NetWeaver all versions

Keywords

error message, filter issue, search engine, data analyzer, sap analytics cloud, dimension filter, DISPLAY_KEY, LONG_TEXT, ABAP dump, query initialization error, mandatory variables, SAP Note 3657316, SAP Note 3448300 , KBA , BW-BEX-OT-BICS-INA , BW INA provider , BW-BEX-OT-OLAP , Analyzing Data , BW-BEX-OT-F4 , MasterData read services , LOD-ANA-LDC-BW , SAC Live Data Connection BW , BW4-AE-API-INA , INA (Information Access Protocoll) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.