Hi,
We have successfully established and validated the connection to SAP HANA [version - hana2sp03] (Success Message : Data Flow is enabled, Remote Tables are enabled ) from SAP Data Warehouse Cloud [version - 2021.1.43 ]
When we try to build graphical views, we are able to add the column views under _SYS_BIC; but during import and deployment we receive the below error.
The calculation View which was used is simple Time Dimension View from M_TIME_DIMENSION table.
[{"description":"Failed to execute a database statement for Artifact T_H_06_TIMDIM of type remoteTable:\n column not allowed: \"DATETIMESTAMP\" in select clause","messageCode":"FAILED_TO_EXEC_STMT","severity":1,"text":"Failed to execute a database statement for Artifact T_H_06_TIMDIM of type remoteTable:\n column not allowed: \"DATETIMESTAMP\" in select clause"},{"saveSucceeded":true}]
Any thoughts on this error is appreciated.
Regards,
Monissha