Skip to Content
0
Jul 23, 2020 at 03:56 PM

SAC doesn't consider dimension with VARCHAR datatype as Time dimension - HANA Live connection

196 Views

Hello All,

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.

Thanks,

Nivetha

Attachments

capture.jpg (98.2 kB)