1472374 - How to convert auditing time objects from GMT to local time zone for MSSQL Database | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1472374 - How to convert auditing time objects from GMT to local time zone for MSSQL Database

Symptom

  • The auditing database stores action time for all the events in GMT time zone
  • If a report is created based on the Activity Universe, all the action times are displayed in this timezone

Read more...

Environment

  • MSSQL Server 2005 as Auditing Database
  • SAP Business Object Enterprise 3.x
  • SAP BusinessObjects Business Intelligence 4.x
  • Activity Universe

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2 ; SAP BusinessObjects Enterprise XI 3.0 ; SAP BusinessObjects Enterprise XI 3.1

Keywords

MSSQL Server, Auditing Universe, Winter/Summer Time, UTC, ADS , KBA , BI-BIP-SRV , CMS / Auditing issues (excl. 3rd Party Authentication) , How To

About this page

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

Search for additional results

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