Skip to Content
1
Nov 16, 2020 at 05:03 PM

How do you output edm.datetime from CDS view - can't incremental load to SAC

724 Views Last edit Jun 22, 2021 at 03:22 PM 2 rev

When I activate a delivered CDS view with ODATA publish true I get the Odata service. In looking at the output metadata, The number fields get the proper ODATA type edm.decimal BUT the date fields are not EDM.DATETIME.. They are edm.STRING. SAP Analytics Cloud needs date fields to support the newer feature for incremental loading.

how can we get this EDM.DATETIME type on date fields (DATS) from the view.

the same issue exists from BW Querys being activated as ODATA services ( as I am pretty sure they use the same underlying features!