Skip to Content
0

How can I load Data with Timestamp MM-DD-YYYY hh:mm:ss into SAP BusinessObjects Cloud (BO Cloud)

Apr 19, 2017 at 09:54 PM

202

avatar image
Former Member

Hi everyone,

I am wondering how I can use IoT data within BO Cloud with datasets based on a standard timestamp, e.g.

MM-DD-YYYY hh:mm:ss. Is there any way to create a time dimension using this format?

thank you so much

stephen

10 |10000 characters needed characters left characters exceeded

Hi Stephen,

Were you able to resolve this?

Did you see this blog already?

https://blogs.sap.com/2016/04/06/use-cloud-for-analytics-to-get-real-time-insights-from-iot-devices/

0
Former Member

Hi,

I was wondering why this issue has been closed as it is still very relevant. I have an oData interface with a field of type Edm.DateTime giving me data in following format: YYYY-MM-DD HH:MM:SS (Y-m-d\TH:i:s) This is automatically converted to date (only) and I lose the time information. In an IoT scenario, I believe the date will not be sufficient.

Any ideas on how to solve this?

Thanks, Patrick

0

It was closed because we never heard back from them.

We support a timestamp feature now (as of 2018.6):

  • The timestamp dimension can be inferred and supported after data is added to a new or existing model.

See
https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/b64df99375084bf4b283023dfb7ccb7b.html


0

Hi Patrick,

This is a current limitation in SAP Analytics Cloud, however we're aware of it and already working on an enhacement, please have a look @ https://launchpad.support.sap.com/#/notes/2598129

In addition to that you may also subsribe to this one here: https://influence.sap.com/sap/ino/#/idea/144681

Thanks, Mark

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

0 Answers