Symptom
Scheduled csv is different than the table-level export within the stories.
- When using the Scheduled Publication option to export a CSV, all the hidden (null-suppressed) cells are also included along with the data.
- However, when exporting directly at the table level using Point of View (PoV) as the scope, the export returns the expected and correct dataset without the hidden cells.
- The ask is to confirm whether this behavior with Scheduled Publication is expected, and whether there is currently a limitation at the Scheduled Publication layer that prevents exports from honoring the Point of View scope which also exports calculated fields from the story, similar to the table-level export functionality.
Environment
SAP Analytics Cloud
Reproducing the Issue
- Create SAC Story
- Schedule Broadcast with csv format
- Receive email and file
- Observe: When using the Scheduled Publication option to export a CSV, all the hidden (null-suppressed) cells are also included along with the data and calculated fields are not exported.
Cause
- The current behavior is a limitation at the Scheduled Publication layer.
-
Scheduled Publications run without a user context, so PoV cannot be applied.
Resolution
This behavior is currently not supported. Scheduled Publication CSV exports do not currently provide an option to apply the same Table-Level Point of View (PoV) scope that is available when exporting directly from a table due to which calculated fields are not exported with current CSV exports.
To address this requirement, an Enhancement Request (ER) has been submitted to SAP requesting the ability to add a Point of View (PoV) selection option to Scheduled Publication CSV exports, allowing customers to generate exports that align with the results returned by table-level PoV exports.
If this functionality is important for your business scenario, please follow the enhancement request and add your vote using the link below: Enhancement Request URL: https://influence.sap.com/sap/ino/#idea/379965.
Customer votes help the product team evaluate demand and prioritize future product enhancements.
Keywords
SAP Knowledge Base Article - Public