SAP Knowledge Base Article - Public

3303949 - Paste filter Values can only filter the first value in SAP Analytics Cloud

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

  1. Create a story based on a live BW model.
  2. Select a dimension as Input Control and initially set it to filter All Members.
  3. Now click the Input Control and choose "Paste Filter Values".
  4. Input several values like:
    2020
    2021
    2022
  5. 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

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.saphttps://hanacloudservices.cloud.saphttps://cloudanalytics.accounts.ondemand.comhttps://hanacloudservices-us.accounts.ondemand.comhttps://www.sap.comhttps://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

Product

SAP Analytics Cloud 1.0