Skip to Content

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Apr 30 at 09:36 PM

    Hi Mudunuri,

    The latest release contains a new feature to compare dates.

    See:
    You can now create a calculation to determine the time interval between two dates. Calculations of this type work only with Date columns and Day-granularity Date hierarchies.

    https://blogs.sap.com/2018/04/23/whats-new-in-sap-analytics-cloud-and-sap-digital-boardroom-release-2018.07/#_Date_interval_calculation

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 23 at 06:28 PM

    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

    Add comment
    10|10000 characters needed 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?

  • avatar image
    Former Member
    Apr 11 at 02:54 PM

    HI.

    Ddid you resolve the problem?

    Can you work with "current" date?

    Add comment
    10|10000 characters needed 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.