Wrong date in BO Webi report with OLAP connection to SAP Datasphere

[sleiva]

Hi all,

I am creating a report in SAP BusinessObjects - Web Intelligence (WebI) using an OLAP connection to SAP Datasphere. The date dimensions are incorrectly visualized in the Webi report (they are shifted back by one day), while their key details correspond to the correct date.

In the image below, the correct date is the one in the center and right columns.

When exploring the Date dimension, it seems that the date is being taken as a timestamp at 00:00 and shifted back by two hours due to the different time zones of the Business Objects server and the Datasphere server.

I have tried converting the date into a timestamp in Datasphere but then the dimension in Webi does not have the date functionalities.

Does anyone have some advise?

Thanks.

[Martin_Kuma]

This seems for me an issue on the BO side, not DSP. "Technical Name" is OK (Key), but View is NOK (Text/Description)

Have you tried to setup the Locale? 

BI Launchpad, Preferences -> Locales and Timezones, Change the option Current time zone to your time zone.

https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/baaf5c869e824d07ab0109e...