How to pull Workflow Start time to Workflow end time in Report(Cube View)

Hi ShivaPrasad​ 

There are api's to retrieve those values for you.  If you search for "time" in the snippet library, you will find them under Scenario e.g. see below

 

 

 

 

 

 

Here is an example to return the time range for a Scenario with Workflow Tracking Frequency -> Range

Sample Code:

	' Declare scenario name
	Dim scenarioName As String = "PriorForecast"
	
	' Retrieve scenario ID
	Dim scenarioId As Integer = ScenarioDimHelper.GetIdFromName(si, scenarioName)
	
	' Retrieve Workflow Start Time from Scenario
	Dim startTimeID As Integer = BRApi.Finance.Scenario.GetWorkflowStartTime(si, scenarioId)
	' Retrieve Workflow End Time from Scenario
	Dim endTimeID As Integer = BRApi.Finance.Scenario.GetWorkflowEndTime(si, scenarioId)
	
	' Derive list of times within range and return as List(Of String)
	Dim objList As List(Of String) = TimeDimHelper.GetIdsInRange(startTimeID, endTimeID). _
									 Select(Function(time) TimeDimHelper.GetNameFromId(time)).ToList()

	' Log result as comma separated values
	BRApi.ErrorLog.LogMessage(si, "Range Scenario Time Range", String.Join(",", objList))

Log Output:

Thanks

Sam