SAP Knowledge Base Article - Public

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

Symptom

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

Environment

  • 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

Cause

  • Must use a Custom Current Date Input Control

Resolution

  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.

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

Product

SAP Analytics Cloud 1.0