Skip to main content
Aug 11, 2021 4:11 PM UTC

Question: In relation to allocation methods in People Planning, is it possible to show some examples of dynamically pulling data from the cube using a Business Rule or Xfcell? When would one be used over the other?

Question

 

Answer

•There are a number of substitution variables available which can be used within the allocation methods. These can be used to create the allocation (e.g |Wage| * |Bonus|), however, they can also be used with XFCell and XFBR strings to retrieve data from a cube for use in the calculation:

OSAdmin_0-1628698249231.png

•XFBR string provides the ability to call a business rule and pass in arguments.  These should be used where logic is required or conditions need to be processed.

OSAdmin_1-1628698270771.png