on 2025 May 06 10:42 AM - last edited 4 weeks ago
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.)
Note. Both ID and Description in this Date Dimension look the same
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.
Request clarification before answering.
Use the standard time dimensions (incl. hierarchies): https://help.sap.com/docs/SAP_DATASPHERE/be5967d099974c69b77f4549425ca4c0/c5cfce4d22b04650b2fd607876...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
34 | |
21 | |
14 | |
8 | |
5 | |
4 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.