Skip to Content

TIMESTAMP fields formatted incorrectly in Analysis for Office

Hi Folks,

I am consuming a HANA Calculation View through Analysis for Office.

One of my fields has the type TIMESTAMP.

When displaying data in HANA Studio, everything appears fine.

However, when displaying data in Analysis for Office, the timestamp values look to be formatted incorrectly.

Has anybody come across this before? And does anybody know a good fix, to ensure the front end presents this information correctly?

Kind Regards,

-Elliott

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 07 at 03:47 PM

    Hello Elliott - if you are using Analysis Office 2.6 please consider reviewing the option "Excel Native Rendering of Date and Time" mentioned in this blog: https://blogs.sap.com/2018/03/11/sharing-experiences-with-analysis-office-2.5-2.6-bihana2018/


    Good luck

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Tammy,

      Thanks for your suggestion. Unfortunately, native rendering didn't seem to help either - it changes the format to something which is still wrong, just in a different way :-)

      still-no.jpg (33.0 kB)