Symptom
- Error "BW_BICS_EQ/120" "Filter with NE is not supported" appears when trying to show List Of value for one dimension in query built on Import S/4HANA connection in SAP Analytics Cloud (SAC)
Environment
- SAP Analytics Cloud 2019.2.2
Reproducing the Issue
- Log on to SAC tenant.
- Create one model on Import S/4HANA connection.
- Create a new query.
- Search for the problematic CDS View and then click Next.
- In Build Query panel, drag the problematic dimension into Filters and then try to open Select Values From dialog.
=> Error appears so the dialog cannot be opened to selected value for filtering.
=> Error details: "code":"BW_BICS_EQ/120","message":{"lang":"ja","value":"Filter with NE is not supported"}
Cause
- When clicking on the "LIST OF VALUES" button, it sends an odata query to the CDS view asking for all the NOT NULL values.
Example: "https://<odata_server_url>/..../<odata service>?$select=<dimension>&$filter=<dimension> ne null" - However, the problematic CDS View doesn't support NE operator. So the error "BW_BICS_EQ/120" is thrown from S/4HANA system.
Resolution
Workaround: input the value directly in the filter, if you know the value you want to filter on.
See Also
- How to find User Assistance for SAP Analytics Cloud?
- Ask a question on the SAP Community!
- 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)
- SAP Analytics Cloud > Learning > Guided Playlists
Your feedback is important to help us improve our knowledge base.
Keywords
SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, LOV, query, build, S4, S/4, S/4HANA, S/4 HANA, S4 HANA, S4HANA, Import, acquire, Odata, entity, CDS View, dimension, list of value, parameter, filter, 120, BW_BICS_EQ, NE, Filter with NE , KBA , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , Problem