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