Symptom
- Paste filter Values can only filter the first value in SAP Analytics Cloud
- For the other values from second line, there is a warning which tells that they are not found and not applied to the filter
Environment
- SAP Analytics Cloud 2022.21
Reproducing the Issue
- Create a story based on a live BW model.
- Select a dimension as Input Control and initially set it to filter All Members.
- Now click the Input Control and choose "Paste Filter Values".
- Input several values like:
2020
2021
2022 - Notice even there is data existed but only the first value (in above example: 2020) is filtered. For the other values, there is warning popup: Some values could not be found and were not applied to the filter. The following values could not be applied to the filter: (In the above example: 2021, 2022)
Cause
The issue is identified as a backend problem in SAP BW environment.
Resolution
First of all, make sure that all prerequisite notes mentioned in the following help page were properly implemented in the BW system:
SAP Help Portal: Searching in Filters and Input Controls (Specifics for SAP BW)
The BW problem was fixed in Note 3305924. Applying this note can solve this issue.
Note: When recording a network trace as per SAP KBA 2280022, although the GetResponse call > Preview will contain no error messages, by implementing above note the issue will be resolved.
See Also
- KBA 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- SAP Community: Have a question? Ask it here
- KBA 2487011 - What information do I need to provide when opening a case for SAP Analytics Cloud?
- KBA 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.
- SAP Analytics Cloud Connection Guide
- Getting Started with SAP Analytics Cloud Expert Community page
- SAP Analytics Cloud Get More Help and SAP Support
- Need More Help? Contact Support or visit the solution finder today!
Your feedback is important to help us improve our knowledge base.
Keywords
SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.sap, https://hanacloudservices.cloud.sap, https://cloudanalytics.accounts.ondemand.com, https://hanacloudservices-us.accounts.ondemand.com, https://www.sap.com, https://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization
analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software , KBA , LOD-ANA-DES , Story Design & Visualizations , BW-BEX-OT-BICS-INA , BW INA provider , Problem