cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

How to improve Date Dimension labels in a line chart from number value (202505) to name ('May')

julia-hamdan
Product and Topic Expert
Product and Topic Expert
0 Kudos
225

Update added below. 

Hello,
I am exposing analytic models from Datasphere to SAC. 

The Date dimension I am using in SAC already has an association to a day view in Datasphere (in a sql view) which enables me to use the hierarchies (day, month, year). 

However in SAC, in a line chart, when the time dimension is on the x-axis, the displayed date label looks like: 
202411, 202412, 202501 etc. (see pic) 
How I can change this display from the number values to the names of the months? (Nov, Dec, Jan, etc.) 

 

juliahamdan_0-1746524319152.png

 

 

Note. Both ID and Description in this Date Dimension look the same 

juliahamdan_0-1746526568430.png

Update: 
I had a call with a colleague from the Analytics team of Datasphere and we went over many elements of what I have built to display the date SAC: from the generated time dimensions in the DSP space, to the SQL view and its type(fact), the dimensions in SQL view, and its association to the day time dimension, ensuring the association is on the correct dimension, and then testing it in the analytic model to see if it works.
Outcome: Even though all elements are done properly, the display of month name and quarter name does not work, and we tested this in the preview within the analytic model. 
It seems that this display is simply not working. I can only conclude that this is a limitation or bug, that happens specifically when using a SQL view. ( when using a graphical view, the display works - but I am not interested in using a graphical view ) 
I will therefore create an incident for this. 

 

View Entire Topic
fijos
Product and Topic Expert
Product and Topic Expert
0 Kudos
julia-hamdan
Product and Topic Expert
Product and Topic Expert
0 Kudos
Hello,
julia-hamdan
Product and Topic Expert
Product and Topic Expert
0 Kudos
Hello, I have been using these Time dimensions in Datasphere to create associations with dates from my datasets, so that I can finally use date hierarchies in SAC - but this still does not allow me to display month names, only month numbers. I also tried to bring the time dimension (time dimension - day specifically by outer joining it to my dataset) but even if i use this date in SAC, I still only have months as numbers in the bar chart. No month names. Can you elaborate if there is a specific way to enable the display of month names e.g. in a bar chart?