3539959 - Incorrect Addition of 53rd Week in SAP Analytics Cloud's 4-5-4 Fiscal Calendar Setting

• The 4-5-4 fiscal calendar setting in SAP Analytics Cloud's Model Preference is not correctly adding the 53rd week. 
• The extra week is being added to the beginning of the 53rd week, for example, FY24 February, instead of being added to the end of FY23 January.

SAP Analytics Cloud

1. Create a model with a 4-5-4 fiscal calendar in SAC.
2. Notice that the extra week is being added to the beginning of the 53rd week, for example, FY24 February, instead of at the end of FY23 January.

• The Week-Based Date Patterns in SAC define how the calendar weeks are calculated in a Calendar year. This includes the First Day of the Week and the First Week of the Year. The Fiscal Settings do not change the Calendar Weeks but only shift by month.
• The issue arises when the Fiscal Weeks are expected to be calculated independently of the Calendar Weeks, which is not currently supported by SAC.

1. Understand that the Week-Based Date Patterns define how the calendar weeks are calculated in a Calendar year.
2. Consider switching from System-managed-time to user-managed time as per the SAC documentation. This allows the time data to be defined manually and to set the starting dates of the week as required.

SAP Analytics Cloud, SAC, 4-5-4 fiscal calendar, 53rd week, incorrect addition, calendar weeks, fiscal settings, system-managed-time, user-managed-time, Excel, time data. , KBA , LOD-ANA-ML-CM , Cube Management , Problem