Skip to Content
0

SAP Analytics Cloud reports unable to get current date and difference between two dates?

Mar 23 at 02:19 PM

66

avatar image

Hi

In SAP Analytics cloud, I would like to get current date in my reports. anyone can help me on this. My source system is Successfactors employee central.

Second thing, I would like to compare 2 date fields in my reports for how long a employee worked in organization. Example - Employee hire(01.01.2016)- Termination date (01.01.2017) Any help will be much appreciated in my both queries.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Ingo Hilgefort
Mar 23 at 06:28 PM
0

Hi,

you mentioned that you would like to have the current date into your report.

Do you have an actual time / date based dimension as part of the source data in the model ?

Thanks

Ingo Hilgefort, SAP

Show 1 Share
10 |10000 characters needed characters left characters exceeded

1. You mentioned that you would like to have the current date into your report.

Yes

2. Do you have an actual time / date based dimension as part of the source data in the model ?

In Successfactors(Source data) there is no actual time/ date based dimension.

One more thing, I would like to compare 2 date fields in my reports for how long a employee worked in organization. Example - Employee hire(01.01.2016)- Termination date (01.01.2017).Do you have any idea on this?

0
Santiago Romero Apr 11 at 02:54 PM
0

HI.

Ddid you resolve the problem?

Can you work with "current" date?

Show 1 Share
10 |10000 characters needed characters left characters exceeded

No, we haven't found a solution for this. Is there any recent release of this date functionality?

If you have any solution please let me know. Thank you for response.

0