SAP Knowledge Base Article - Public

3014159 - Filter by Range window cannot be shown when filtering the date dimension using filter by range in page filter on in SAP Analytics Cloud (SAC) story

Symptom

  • Filter the date dimension using filter by range in page filter on SAC Story, the story keeps loading and Filter by Range window does not display
  • Story is based on SAP Data Warehouse Cloud live connection

Environment

  • SAP Analytics Cloud (Enterprise) 2021.21.14

Reproducing the Issue

  1. Open and edit the Story based on SAP Data Warehouse Cloud live connection.
  2. Edit the story.
  3. Click on the Page filter, select > Dimension > [Date Dimension] >Select by Range.
    It keeps loading, set Date range window does not show up.

Resolution

Please make sure the lowest level of all time dimensions follows the time dimension note on:
https://help.sap.com/viewer/c8a54ee704e94e15926551293243fd1d/cloud/en-US/5aae0e95361a4a4c964e69c52eada87d.html
 
In order to use a time dimension in SAP Analytics Cloud, you must create your dimension by following the procedure at Creating Time Dimensions. Manually-created or other time dimensions may not function correctly.
 
In addition, attributes in an analytical dataset that are mapped to a time dimension via an association must have technical names that respect the following naming conventions:
- *_DATE for Date/Day level
- *_CALMONTH for Month level
- *_CALQUARTER for Quarter level
- *_YEAR for Year level

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,DWC,hang, no response, freeze , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0