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)

    🙂

     

SamRichards's avatar
SamRichards
Contributor
3 years ago

Hey Chris,

What are you trying to do here? If you attach this inside of a Finance.Calculate rule it will have to be attached to the cube and then it will run every time you click calculate/consolidate. I think that could get messy because what happens when that CV time is different from user to user. If you are evaluating some time base on what a user is looking at in a CV I would suggest using a custom calculation and a parameter because it is session specific, and you know what that parameter is going to be when you run the custom calculation.