Symptom
Unable to add granularity as 'second' in date dimension in a model in SAC.
Environment
SAP Analytics Cloud Version 2023.21.16
Reproducing the Issue
- Login to SAC.
- Open the model
- Under Edit, select Add dimension.
- Select dimension type as 'date'.
Granularity as 'second' in date dimension in a model is not present.
Cause
This is behavior by design.
Resolution
SAC currently doesn’t offer 'second' as the smallest granularity for the date dimensions. Enhancement request has already been done regarding the time dimension. You can vote for the same: Improvement Request Details - Customer Influence (sap.com)
See Also
- Time Hierarchies | SAP Help Portal
- Learn About Dimensions and Measures | SAP Help Portal
- 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!
Keywords
time, dimension, SAC, model , KBA , LOD-ANA-DES , Story Design & Visualizations , Product Enhancement
Product
SAP Analytics Cloud 1.0