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

[manish_pohuja]

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

[shreenithnaik]

Hi manish.pohuja ,

Thanks for your question.

In regards to consulting with a colleague of mine about your question, would suggest you to open a ticket with SAP Signavio Support Team via SAP for ME. The team should be able to help you with this issue.