Book: Footer using UTC time zone
This is a known issue: PF-3331. I do not see this yet on Idea Stream but you could open a case and ask that your company be added to this known issue.
As a work around, you can use this dashboard extender rule on cube views:
Namespace OneStream.BusinessRule.DashboardStringFunction.XFR_Show_Est_timezone Public Class MainClass Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As DashboardStringFunctionArgs) As Object Try If args.FunctionName.XFEqualsIgnoreCase("TimeHelper") Then Dim now As DateTime = DateTime.UtcNow Dim easternzoneid As String = "Eastern Standard Time" Dim easternZone As TimeZoneInfo = TimeZoneInfo.FindSystemTimeZoneById(easternZoneId) Dim convert As Date = TimeZoneInfo.ConvertTime(now, easternzone) Return convert.ToString End If Return Nothing Catch ex As Exception Throw ErrorHandler.LogWrite(si, New XFException(si, ex)) End Try End Function End Class End NamespaceThe reason it's pulling that time is because it uses the server time, which is UTC. This was initially done so that when a book is run, users can convert to their local time.
If you set up a dashboard extender BR and go to the cube view's footer, and paste in the following:
XFBR(XFR_Show_EST_timezone, TimeHelper) ESTThat will run all cube views in a book as ET. The caveat with this work around is you have to pick one time zone, e.g. EST.
Also, if you search One Community for "Footer UTC" or "time zone" you will see other suggestions.
