cancel
Showing results for 
Search instead for 
Did you mean: 

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

sleiva
Newcomer
181

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.

sleiva_2-1742311417667.png

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.

sleiva_1-1742311353760.png

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.

View Entire Topic
Martin_Kuma
Active Participant
0 Kudos

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...