SAP Knowledge Base Article - Public

3092698 - Time zone conversion cannot be applied to DATATIME column used in functions to create calculated column in embedded stories

Symptom

  • You can adjust the time zone of DATETIME fields by applying a conversion as per end user's time zone on DATETIME column selected in Query Designer only
  • Such time zone conversion cannot be applied to DATATIME column used in functions such as DAY, DATE, MONTH , YEAR while creating a calculated column, which may result in difference in the data
    Joining date(UTC) - stored in databaseJoining date (IST)- Shown to end userDAY (Joining date)- Shown to end user
    26 August, 2020, 11:00 pm27 August, 2020, 04:30 am27
    26 August, 2020, 08:00 am26 August, 2020, 01:30 pm26

Environment

  • Embedded stories in SAP applications

Reproducing the Issue

  1. Create a new embedded story by choosing a connection.
  2. From the Query Designer,  drag and drop an object on the canvas having DATETIME column.
  3. Select the DATETIME column from object's column listing.
  4. Create a Calculated Column using Formula like DAY, DATE, MONTH , YEAR and use the same DATETIME column.
  5. Click on Preview button.
        => The DATETIME column and the calculated column may show difference in output data.

Cause

  • This is a limitation of embedded stories.
  • Time zone conversion is a representational feature which is applied when the query output has columns with DATETIME  data type. This adjusts the values to client time zone.
  • In case of DAY, DATE, MONTH , YEAR formula, the output is a number to which no conversion is applied. This will result in difference in data based on the applied time zone offset

Resolution

  • You can submit one enhancement request for this limitation according to SAP KBA 2424376.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,  OEM, embed, embedded, SF, SFSF, S4HC, S/4HANA Cloud, timezone, time zone, convert, conversion, formula, calculated, calculation, datetime, date, time, date-time , KBA , LOD-ANA-OEM , Embedded usage of SAP Analytics Cloud , LOD-SF-ANA-SAC , People Analytics (Analytics Cloud for SF) , CA-GTF-SB-S4H-SAC , SAP S4H embedded SAC UI integration , Product Enhancement

Product

SAP Analytics Cloud 1.0