SAP Knowledge Base Article - Public

3060819 - Time based filters may not work or return errors in SAP Analytics Cloud (SAC) & SAP Digital Boardroom KBA Template

Symptom

The following error occurs in SAP Analytics Cloud (SAC):

  • When filtering with time based dimensions (i.e. Calendar Day) error is thrown: "Filtering on string type calculated dimension by range is not supported. Please remove invalid filter"

Environment

  • SAP Analytics Cloud (Enterprise) 2021.7.7
  • Live SAP BW Data Connection

Reproducing the Issue

  1.  Open a story based on Live SAP BW data connection with filters based on time dimensions
  2.  Apply the filter
  3.  Refresh fails with error: ""Filtering on string type calculated dimension by range is not supported. Please remove invalid filter"

Cause

This issue is currently under investigation by development.

Resolution

This issue is currently under investigation by development.

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, 0CALDAY, Calender day, Calendar day , KBA , LOD-ANA-DES-COR , SAC Core story functionality - widgets, geo, design, etc , LOD-ANA-LDC-BW , SAC Live Data Connection BW , LOD-ANA-DES , Story Design & Visualizations , Known Error

Product

SAP Analytics Cloud 1.0