cancel
Showing results for 
Search instead for 
Did you mean: 

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

former_member646700
Participant
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

saurabh_sonawane
Active Contributor
0 Kudos

Hi,

You have to change the data type in HANA instead of varchar use date and time or date as per your requirement.

and try to use a date function to modify the date in HANA.

Thanks,

Saurabh S.

former_member646700
Participant
0 Kudos

Hi Saurabh,

I tried with the below. But it gives an error.

I created a calculated column 1 with type 'VARCHAR' and created an another calculated column 2 with type 'TIME' (Date as well) and passed the calculated column 1 as input for the date function. But it throws an error.

SAP DBTech JDBC: [2048]: column store error: search table error: [70006931] message not found;message not found; exception 70006931: attribute value is not a date or wrong syntax; $message$=attribute value is not a date or wrong syntax;[here]daydate("Statement_Start_Time_Test", 'YYYY-MM-DD HH:MI AM'), Statement_Start_Time_Test = '2020-07-23 17:56:30.0355820'[string](6931)

calculated column 1:

calculated column 2:

saurabh_sonawane
Active Contributor
0 Kudos

hi please change your datatype = datetime