SAP Knowledge Base Article - Public

3035442 - Leap year incorrectly calculated in dynamic date filter in SAP Analytics Cloud (SAC)

Symptom

  •  In the dynamic date filter incorrect range will be calculated for leap year 2020:

Range 1 : Offset Current Month (01.02.2020 - 28.02.2020)

  • It should be 01.02.2020 - 29.02.2020, as 2020 was a leap year.
  • Data source independent.

Environment

  • SAP Analytics Cloud (Enterprise) 2021.2.8

Reproducing the Issue

  1. Login to SAC.
  2. Create a story with a chart e.g. Comparison - Bar/Column on a sample model [BestRunCorp_Retail]
  3. Select Measures e.g. [Sales Revenue]
  4. Add a Story filter e.g. in the story main panel Tools - Add Story Filter/Prompt - Add Time Filters e.g. "Previous" - "Month"
  5. Edit filter: 
    1. Create a custom Current Date - Create Current Date Input Control e.g.:
      • Name [Test Current Date], Current Date Type [Custom Current Date / Period], Granularity [Month], Date [2021.Feb]
    2. Modify "Range 1" e.g.:
      • Range Type [Offset], Granularity [Current Month]
      • Offset Direction [Look Back], Offset Granularity [Year], Offset Amount [1]
  6. Incorrect range will be calculated: Range 1 : Offset Current Month (01.02.2020 - 28.02.2020)

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 , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0