Symptom
- Create a story based on the live data connection to BW system and enable the Optimized Design Experience mode for this story
- After adding a table into this optimized story
=> Observe that the error message "Error during execution CL_BICS_INA_COMMONS APPLY_FILTERS CARTESIAN PART CANNOT BE CONVERTED" would appear on table
=> On Builder panel of this table, observe that some unusable filters would appear on Filter part - After adding a chart into this optimized story
=> Observe that the error message "Failed to fetch data" would appear after adding some dimensions and measures into this chart
Environment
SAP Analytics Cloud 2023.21.13
Reproducing the Issue
- Create a story based on the live data connection to BW system and enable the Optimized Design Experience mode for this story
- Add a table into this optimized story
- Observe that the error message "Error during execution CL_BICS_INA_COMMONS APPLY_FILTERS CARTESIAN PART CANNOT BE CONVERTED" would appear on table
3.1 On Builder panel of this table, observe that some unusable filters would appear on Filter part - Insert a chart into this optimized story, and add some dimensions and measures for this chart
- Observe that the error message "Failed to fetch data" would appear
Cause
The issue is caused by a defect in the BW system.
Resolution
Apply the following SAP Notes:
3429119 - "BICS: Pre-Query variables exposed as dynamic filter (state)" in BW system
3429756 - BICS INA: Error while applying Filter. CARTESIAN PART CANNOT BE CONVERTED 2
3281093 - InA: Error when setting a filter on dimension that has an authorization variable
See Also
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening an incident for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using Google or Bing:
- https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- Need More Help? Contact Support or visit the solution finder today!
Your feedback is important to help us improve our knowledge base.
Keywords
sapanalyticscloud, sap analytics cloud, sap analytical cloud, SAC, sap analyst cloud, Story, story, Stories, stories, Story 2.0, story 2.0, Optimized Design Experience mode, ODE, ode, Optimized View mode, OVM, ovm, table, chart, live BW, characteristics, filter, replacement path, variable, INA, CL_BICS_INA_COMMONS APPLY_FILTERS ILLEGAL_HIERARCHY, CL_BICS_INA_COMMONS APPLY_FILTERS ILLEGAL_FILTER_CHARACTERISTIC , KBA , LOD-ANA-DES-OFLTR , SAP Analytics Cloud Optimized view mode filtering , Problem