I'm trying to create a time series graph in SAC on top of a HANA calculation view through live connection.
The time format in HANA was in 'YYYY-MM-DD HH:MI:SS:FFS'. So I had to create a calculated column on top of the existing dimension to convert the format to 'YYYY-MM-DD HH:MI AM' and this calculated column was created with datatype 'VARCHAR'. I can see the desired output in HANA.
But, when I try to create a timeseries graph in SAC, this calculated column with type 'VARCHAR' is not showing as a time dimension in SAC.
Also I'm not able to change the time format at the model level as it is a live connection.
Can anyone help me with this? I want to convert the time format from 'YYYY-MM-DD HH:MI:SS:FFS' to 'YYYY-MM-DD HH:MI AM' with datatype timestamp at HANA level. So it will be visible as time dimension in SAC.