Skip to Content
0
Oct 07, 2019 at 07:22 PM

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

146 Views Last edit Oct 07, 2019 at 08:04 PM 3 rev

2019-10-07-15-23-37-bi-launch-pad-internet-explore.png2019-10-07-15-23-58-bi-launch-pad-internet-explore.pngFollowed the KB-1472374 -https://launchpad.support.sap.com/#/notes/1472374. Deployed the script on our Audit DB (MSSql server) . Created an object in the unx Action Time Local and Set the type of this object to: date and In the Select text box typed the following dbo.Get_UTC_Time(AUDIT_EVENT.Start_Time). After publishing the universe when i tried to pull the objects User and Action Time Local, BO is generating 2 select sql statements instead of 1.