TIMESTAMP fields formatted incorrectly in Analysis for Office

[former_member277290]

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

[TammyPowlas]

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

[former_member277290]

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 🙂