SAP Knowledge Base Article - Preview

1359599 - MySql Convert UTC GMT to PST

Symptom

User want to see in PST time Zone all the Time but its showing GMT Time Zone in Audit database tables.

Unable to see the correct time zone for document retrieved time/action time object from the report level. Reproducing the Issue Create a report with Action Time object from Audit universe Cause GMT Time Zone in Audit database tables. Resolution -

Open Activity Universe- - Click Actions Class - Click Action Time object - Change the Type to Character - Change the Action Time universe objects select statement to to_char(AUDIT_EVENT.Start_Timestamp -420/1440,'HH:MI:SS AM')


Read more...

Environment

  • BusinessObjects Enterprise XIR3.1
  • Universe Designer

Product

SAP BusinessObjects Enterprise XI 3.1

Keywords

KBA , BI-BIP-SL , Semantic Layer , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.