on 07-23-2020 4:56 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.