Skip to Content
0
Jul 14, 2023 at 06:38 AM

LAST / CAST function issue in SAP Signavio Signal while defining Business Objects

265 Views

1. Issue in converting STRING timestamp to TIMESTAMO while using CAST function. Error Attached.

Query used:

select

CAST ( activity_master_file__002__1689242173252_etl_378_csv.timestamps as TIMESTAMP) as "TIMESTAMPS" from activity_master_file__002__1689242173252_etl_378_csv

2. Issue in calculating Cycle Time using LAST function. Error Attached.

Query Used:

SELECT

AVG(
(SELECT LAST(X.timestamps) AS "A" FROM activity_master_file__002__1689242173252_etl_378_csv AS "X")
-
(SELECT LAST(Y.timestamps) AS "B" FROM activity_master_file__002__1689242173252_etl_378_csv AS "Y")
) AS "TPT"
FROM activity_master_file__002__1689242173252_etl_378_csv

3. Activity file with DATETIME datatype selected as TIMESTAMP posing an issue of conversion to PARQUET files. This works well if the DATETIME field is selected as STRING. Steps executed are attached.last-function-issue.pngthroughput-time-query.pngcast-function-issue.pngstep-1-upoad-of-csv-file.pngstep-2-configuration-of-table.pngstep-3-selecting-data-type-as-timestamp.pngerror-in-conversion-from-csv-to-parquet.pngSource Data Link