3577424 - SAC Date Hierarchy Format Requirement

The requirement is to change the sequence within the time hierarchy from "Year -> Quarter -> Month" to "Month -> Quarter -> Year".

SAP ANALYTICS CLOUD

1. Open the dimension table for the date dimension for exemple, where an existing hierarchy is already defined.   
2. Change the member management setting to user management, allowing you to modify the dimension parameters as needed.  
3. After making this adjustment, you will be able to configure the hierarchies accordingly.  
4. Click the "+" icon to add a new hierarchy. The hierarchy builder will open, allowing you to configure it as needed.  
5. To define the hierarchy levels, click on the three dots next to the properties and assign them as Level 1, Level 2, and so on, based on the desired structure.  
6. While doing the steps the structure adjusted to set "Year" as the highest level by default

This is by design. The Year in the date dimension will always be set at the highest level.

This behavior is by design and is explained in Creating a Time Hierarchy.The system is structured to follow these guidelines when creating time hierarchies:  

• The hierarchy has the mandatory Year semantic type as the highest level.
• The semantic types within the hierarchy are ordered from the biggest to the smallest time unit. For example, Month must be below Quarter, and above Week.
• Each semantic type within the hierarchy is only used once, except for the Other semantic type.
• If the hierarchy uses the semantic type Month, do not include the semantic type Period, and vice versa.
• The lowest level of the hierarchy is the ID property if there is one. Otherwise, it must be a unique property.
• Description properties cannot be used in the hierarchy.

• Creating a Time Hierarchy
• Cannot Change Date Dimension Default Hierarchy in SAP Analytics Cloud
• 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
• 2487011 - What information do I need to provide when opening an incident for SAP Analytics Cloud?
• 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
• Search for SAP Analytics Cloud content using Google or Bing:
• https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
• https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
• Note: Add relevant text or warning/error messages to the text search field to filter results
• SAP Analytics Cloud Connection Guide
• Getting Started with SAP Analytics Cloud Expert Community page
• SAP Analytics Cloud Get More Help and SAP Support
• Need More Help? Contact Support or visit the solution finder today!

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, Hierarchy, Model, Time dimension, User management, time hierarchies. , KBA , LOD-ANA-PL , Planning , LOD-ANA-ML , SAC Modelling , Problem