Time always returns 0001-01-01 in BR when using XFBR in Cube View

Hi Manju, most easy is to use substitution variables to insert these kind of info into your BR. 

Use the glasses on top and select Substitution Variables on the left bottom to see what is available. e.g. |POVTime|.

in this case you don't use ! but only the pipes.

It should also be noted that WF* variables are reliably populated only when items are used into an actual Workflow step, for example in a custom Dashboard used in a Workspace step. Executing a cube view on its own will likely not have those variables set.

I agree with MarcR​ 

You can also use |POVYear| to avoid any manipulation if you only want to retrieve the Year from POV e.g.

i tried both |Time| and |POVTime| it didn't work

including XFBR function 

XFBR(BR_Name, FunctionName, SelectEntity = |Entity|, Time = |Time| ) 
Time = |POVTime| it didn't work.

BR,

Public Function BR_Name(  ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As DashboardStringFunctionArgs) As String

Try

Dim Entity As String = ""

If args.NameValuePairs.ContainsKey("SelectEntity") Then

Entity = args.NameValuePairs("SelectEntity")

Else

Return "" ' No entity → return nothing

End If

Dim POVTime As String = ""

Dim povYear As Integer = 0

If args.NameValuePairs.ContainsKey("Time") Then

POVTime = args.NameValuePairs("Time") ' e.g., "2025M12"

If POVTime <> "" Then

Try

povYear = CInt(Left(POVTime, 4))

Catch

povYear = 0

End Try

End If

End If

Dim ENTRemoveEntities_2026 As String() = {"Entity1","Entity2","Entity3"}

Dim EXITRemoveEntities_2026 As String() = {"Entity4","Entity5"}

Dim HistoricalENT As String() = {"Entity1","Entity2","Entity3"}

Dim HistoricalEXIT As String() = {"Entity4","Entity5""}

If povYear >= 2026 Then

If Entity = "Entity3" Then

Return "ENT" 

ElseIf ENTRemoveEntities_2026.Contains(Entity) Then

Return "" ' ENT removed

End If

' EXIT rules

If EXITRemoveEntities_2026.Contains(Entity) Then

Return "" ' EXIT removed

End If

' Default for 2026+ other entities

Return "ENT"

End If

If HistoricalENT.Contains(Entity) Then

Return "ENT"

End If

If HistoricalEXIT.Contains(Entity) Then

Return "EXIT"

End If

Return "ENT"

Catch ex As Exception

Return "ENT"

End Try

End Function