Forum Discussion

chris_rothermel's avatar
chris_rothermel
Contributor
3 years ago

Using standard substitution variables in regular Business Rules; Example: |CVYear|

  In an earlier post a user named Sam helped me find a way to find the value of a variable in a Custom Calculate job using the Parameter field.  Now, how can we access the value of the parameter in...
Finance
  • chris_rothermel's avatar
    chris_rothermel
    3 years ago

    The named pairs passed as a parameter in a Custom Calculate job worked.  Today I found a better way to avoid having parameters passed to a custom calc.  We can use T#WFTime, and to access it I used

    BRApi.Workflow.General.GetWorkflowUnitPk(si).TimeKey.ToString.Substring(0,4)

    🙂

     

chris_rothermel's avatar
chris_rothermel
Contributor
3 years ago

I'm getting a little closer.  GetLiteralParameterValue.

Dim sValue As String = BRApi.Dashboards.Parameters.GetLiteralParameterValue(si, False, "ColorFont1_PLP")
api.LogMessage("This is the value of the parameter: " & sValue)

 

Description: This is the value of the parameter: XFDarkBlueText

However CVYear doesn't show. 

Dim sValue As String = BRApi.Dashboards.Parameters.GetLiteralParameterValue(si, False, "CVYear")

Dim sValue As String = BRApi.Dashboards.Parameters.GetLiteralParameterValue(si, True, "CVYear")

This is the value of the parameter: Unknown11/3/2022 3:02:36 PMInformation    

 

 

 

 

  • JackLacava's avatar
    JackLacava
    Honored Contributor
    3 years ago

    The substitution variables starting with CV are specific to CubeViews. They don't appear anywhere else. Unless you're executing this code in a CubeView Extender (and even there, you'd need different code), you likely won't find the variable anywhere.

    When you right click -> Calculate on a Cube View cell, you're launching a Calculate operation on the whole Data Unit. That will execute any Member Formulas associated with the Scenario or Account/Flow/UD members, as well as Finance Business Rules attached to the cube (in the FinanceFunctionType.Calculate "case" block). There, you can retrieve the values of the members defining the data unit (Cube, Scenario, Entity, Parent Entity, Consolidation, and Time) from the objects in Api.Pov.

     

  • chris_rothermel's avatar
    chris_rothermel
    Contributor
    3 years ago

    The named pairs passed as a parameter in a Custom Calculate job worked.  Today I found a better way to avoid having parameters passed to a custom calc.  We can use T#WFTime, and to access it I used

    BRApi.Workflow.General.GetWorkflowUnitPk(si).TimeKey.ToString.Substring(0,4)

    🙂

     

    • chris_rothermel's avatar
      chris_rothermel
      Contributor
      3 years ago

      I meant T#WFYear