Using ParamHelper for CubeViews (Scenario driven by Time Selected)

[GW]

Hi,

I am currently working on creating a ParamHelper business rule to be used in a CubeView. The goal is to have the S#scenario driven by the time dimension parameter selected by the user, rather than by the workflow time. For example, if T# contains M1, the scenario that should be returned is S#Projection. I would appreciate any pointers or guidance.

Thanks in advance for your help!

[RobbSalzmann]

Can you post what you have so far?  Might be easier to help you fix/adjust what you have vs trying to guess at what you might need.

Right off the bat I would recommend not using .Contains for this.

strTimeFilt.Contains("M1") will evaluate true for M1, M10, M11, and M12.

instead try:

strTimeFilt.EndsWith("M1")

[GW]

Thanks for the suggestion. I was only able to create a functional one below that works based on workflow time, rather than user time parameter selection.

If args.FunctionName.XFEqualsIgnoreCase("GetScenarioByTime") Then
	'Get Time from current Workflow
	Dim myWorkflowUnitPk As WorkflowUnitPk = BRApi.Workflow.General.GetWorkflowUnitPk(si)
	Dim wfTime As String = BRApi.Finance.Time.GetNameFromId(si, myWorkflowUnitPk.TimeKey)

	If wfTime.Contains("M1") Or wfTime.Contains ("M2") Or wfTime.Contains ("M3") Then
		Return "S#Projection1"
	Else If wfTime.Contains("M4") Or wfTime.Contains ("M5") Or wfTime.Contains ("M6") Then
		Return "S#Projection2"
	Else If wfTime.Contains("M7") Or wfTime.Contains ("M8") Or wfTime.Contains ("M9") Then
		Return "S#Projection3"
	Else If wfTime.Contains("M10") Or wfTime.Contains ("M11") Or wfTime.Contains ("M12") Then
		Return "S#Projection4"
	End If
End If

[RobbSalzmann · Accepted solution]

The code you posted will return as follows:
S#Projection1 for periods M1, M2, M3, M10, M11, and M12.
S#Projection2 for periods M4, M5, M6
S#Projection3 for periods M7, M8, M9
S#Projection4  - never

The code will never return "S#Projection4" because that If statement will never get called. See my first comment. above.

You have a couple choices.  Use .EndsWith() or put this evaluation first:
If wfTime.Contains("M10") Or wfTime.Contains ("M11") Or wfTime.Contains ("M12") Then
Return "S#Projection4"

[RobbSalzmann]

A little fun with strings, this will also meet your requirement:

'Remember to add the import: Imports System.Text.RegularExpressions
If args.FunctionName.XFEqualsIgnoreCase("GetScenarioByTime") Then
	Dim myWorkflowUnitPk As WorkflowUnitPk = BRApi.Workflow.General.GetWorkflowUnitPk(si)
	Dim wfTime As String = BRApi.Finance.Time.GetNameFromId(si, myWorkflowUnitPk.TimeKey)
	Dim regex As Regex = New Regex("\d+$")

	Return $"S#Projection{CStr(CShort((CShort(regex.Match(wfTime).Value)+1)/3))}"
End If