SAP Knowledge Base Article - Public

2958705 - How to filter by Calendar Week or Half Year in SAP Analytics Cloud (SAC)


In SAP Analytics Cloud (SAC):

  • Need to filter by Calendar Week or Half Year
  • Predefined Granularity does not allow to filter by Calendar Week, or Half Year the only options are: 
    Year, Quarter, Month, Current Year, Current Quarter, Current Month


  • SAP Analytics Cloud (Enterprise) 2020.15.5

Reproducing the Issue

  1. In a Story, click on the Add Filter button
  2. Select Dimension / [Your Date Dimension] / Filter by Range
  3. The only available values for Granularity are:  Year, Quarter, Month, Current Year, Current Quarter, Current Month


  • Must use a Custom Current Date Input Control


  1. In a Story, click on the Add Filter button
  2. Select Dimension / [Your Date Dimension] / Filter by Range
  3. From the Current Date combobox (picklist) select Create Current Date Input Control 
  4. From the Granularity combobox select Week or Half Year

See Also

Your feedback is important to help us improve our knowledge base.


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, date, calendar week, half year , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem


SAP Analytics Cloud 1.0