Skip to Content
0
Dec 04, 2020 at 05:51 AM

Error While Consuming Column Views from _SYS_BIC in SAP Data Warehouse Cloud

143 Views

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