Forum Discussion

Manju's avatar
Manju
New Contributor II
2 months ago
Solved

Time always returns 0001-01-01 in BR when using XFBR in Cube View

Hi, I am calling a Business Rule (BR) in a Cube View using XFBR as follows: XFBR( BR_ParamHelper, FunctionName, WFname = |WFText2|, SelectEntity = |!WF_AssignedEntity!|, Time = |!Time!| ) Inside t...
cubeview
XFBR
  • MarcR's avatar
    MarcR
    2 months ago

    Hi Manju, most easy is to use substitution variables to insert these kind of info into your BR. 

    Use the glasses on top and select Substitution Variables on the left bottom to see what is available. e.g. |POVTime|.

    in this case you don't use ! but only the pipes.

JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
2 months ago

It should also be noted that WF* variables are reliably populated only when items are used into an actual Workflow step, for example in a custom Dashboard used in a Workspace step. Executing a cube view on its own will likely not have those variables set.