Forum Discussion

Cheryl_Lamkin's avatar
Cheryl_Lamkin
New Contributor II
5 months ago

Book: Footer using UTC time zone

When I run a OneStream book, the time zone in the footer is in UTC, which is 5 hours different from my time zone CST.   However, if I run the individual cube views that are included in that book, the...
Books
  • T_Kress's avatar
    T_Kress
    5 months ago

    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 Namespace

    The 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) EST

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

T_Kress's avatar
T_Kress
Contributor III
5 months ago

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 Namespace

The 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) EST

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