Symptom
- By default, when date dimension is set to be displayed as flat presentation, 0() is displayed for empty date value.
- Is there any method to change this display value for empty date?
Environment
SAP Analytics Cloud 2024.2
Reproducing the Issue
- Log on to SAP Analytics Cloud and create a story based on an acquired data model.
- Add a table and add a Date dimension which contains empty date into this table.
- Change this Date hierarchy display as Flat presentation.
- Note that, for empty date, it displays as 0().
Resolution
Using the following step to customize the display of the empty date. This example will change the default display to character -.
- Edit the acquired data model.
- Open the Date dimension to edit.
- Set Default Booking Behavior as Book to Unassigned.
- Set Member Management as User-Managed.
- Edit the empty date row, which should be the first row of the table in the left of the current page. Change the value of Day. E.g. Change Day to -.
- Save the changes of the model.
Keywords
date, datetime, time, timestamp, format, yyyy-mm-dd, SAC, formatting , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem
Product
SAP Analytics Cloud 1.0