Skip to Content
1

Date in odata service for SAP Analytics Cloud

Jan 11 at 07:33 AM

63

avatar image

Hi,

we have created a very simple odata service in a S/4 HANA System showing some deliveries.

There are some fields representing dates like delivery date etc.

All these date fields are mapped to edm.Datetimeo format.

In SAP Analytics cloud we created a model based on a connection to this service (S/4 HANA type).

Now when creating the model, the dates are shown as date field and assigned to dimension.

The problem is: We want to use the dates in a time series chart, but the dates are not showing in the selection. Also when using a normal chart , the x axis cannot be sorted correctly according to date.

What are we missing ? How could the dates be made recognizable as "date" ?

Any help appreciated.

10 |10000 characters needed characters left characters exceeded

Hi Marcus

Were you able to figure this out?

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Henry Banks
Jan 11 at 11:06 AM
1

Hi,

how are you connecting to this S/4 content - Are you doing "Import data from OData service" or "Live data from S/4"?

this page in the Help guide: https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/bdf055159cbb4f36b26c93ccb0c56066.html

regards, H

Share
10 |10000 characters needed characters left characters exceeded