Forum Discussion

GW's avatar
GW
New Contributor II
2 years ago

Using ParamHelper for CubeViews (Scenario driven by Time Selected)

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...
Cubeview
Finance
XFBR
  • RobbSalzmann's avatar
    RobbSalzmann
    2 years ago

    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's avatar
RobbSalzmann
Valued Contributor II

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's avatar
GW
New Contributor II
2 years ago

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's avatar
    RobbSalzmann
    Valued Contributor II
    2 years ago

    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's avatar
      RobbSalzmann
      Valued Contributor II
      2 years ago

      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