Appendix A: Expressions

Expressions are used in multiple areas of the Planning solutions.

  • OneStream uses ADO.NET engine to interpret expressions; there is no parser involved.

  • The expression evaluator supports these operators:

    • Open bracket ‘(‘ and close bracket ‘)’

    • Addition ‘+’, subtraction ‘-‘, multiplication ‘*’, division ‘/’

    • Modulo ‘%’

    • Equality ‘=’, inequality ‘!=’

    • Bigger than ‘>’, bigger than or equal ‘>=’, smaller than ‘<‘, smaller than or equal ‘<=’

    • Logical and ‘&&’, logical or ‘||’

    • Conditional ‘IIF’

  • Can use any Substitution Variable or Global Driver.

    • (0.80*|Wage|)+(0.20*|Wage|*|Overtime|)

  • XFBR String

    • Calls and passes arguments to a Business Rule that can look up a value in a Cube or process conditions to return a value or string.

    • (XFBR(PLP_ParamHelper, GetDriverValue, ud2Member=|Code2|, entityMember=|Entity|, accountMember=[Wage Increase Pct])) / 100 * |FTE|

  • XFCell (may perform better than XFBR String)

    • Queries Cube data cell value and can pass Substitution Variables and even XFBR’s

    • Missing members are retrieved from the POV

    • ((XFCell(E#|Entity|:C#Local:S#BudgetV1:
      T#2017M1:V#Periodic:A#[Wage Increase Pct]:F#None:O#Forms:I#None:U1#None:
      U2#|Code2|:U3#None:U4#None:U5#
      None:U6#None:U7#None:U8#None)) * |Wage|) / 12