Symptom
Formatting discrepancy in Excel export for story publication in SAC
Environment
SAP Analytic Cloud 2025.21.11
Reproducing the Issue
- Login to SAC
- Navigate to files> Open story containing a table widget, in view mode
- Selected File > Schedule Publication
- Populate the necessary details such as Event Name, Start Date, Story View, File Name, etc. as per preference
- Choose File type as .xlsx/.csv
- Go to "File Settings" under "Distribution" and select the checkbox for "Include Formatting (converts numbers to strings)"
- Select Create
- Download the .xlsx/.csv file after the publication has completed successfully.
Notice: The data formatting in downloaded file does not match the data formatting in the story table
Cause
By Design Behavior of the product.
- The publishing feature operates with the "All" scope and does not support the "Point of View" scope.
- Using the "All" scope preserves only the model formatting.
Resolution
Kindly submit an enhancement request to request this feature as per - 2424376 - How do you create an enhancement request and provide feedback for SAP Analytics Cloud?
See Also
- Schedule Publications | SAP Help Portal
- 3570727 - Issue with 'Export to Excel' functionality with scope All in SAP Analytics Cloud (SAC) - SAP for Me
- 2424376 - How do you create an enhancement request and provide feedback for SAP Analytics Cloud? - SAP for Me
- 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.
- Getting Started with SAP Analytics Cloud
- Need More Help? Contact Support or visit the solution finder today!
Keywords
sac, datasphere analytic models, live tunnel connection, include formatting, excel publication, formatting discrepancy, numerical formatting, point of view scope, all scope, pdf export, enhancement request , KBA , LOD-ANA-SCH , SAC Story Scheduling and Publication , LOD-ANA-UNS-EXP , Unified Story PDF/PPT/Excel/CSV Export , Product Enhancement
SAP Knowledge Base Article - Public