5. Use ‘settemporary’ to evaluate all your properties in one

Rather than typing individual expressions directly into the default value box for properties to be calculated, OrgVue enables multiple properties to be set via a single expression held in a specified property. This means only one expression is evaluated for each node but a range of calculated values are returned for multiple properties, which:

  • Increases performance in datasets where multiple properties contain calculated values.
  • Allows the reuse of traversals (expressions calculating up and down the tree) without needed to perform these calculations again or rely on dependency order.

To use settemporary:

  1. Create a property called “Expressions” (or any other suitable name).
  2. Set the default value of this property as node.settemporary({ a:x, b:y, …, c:z}) where:
    • a, b, c = the names of properties that are going to be populated with calculated values, and
    • x, y, z = the expressions to be evaluated.

Note: the names that need to be listed are the property key values, exactly as they appear in the Edit Property dialogue. You cannot include any dependencies in the settemporary expression, so you couldn’t include bonus (10% of salary) and total cost (salary+bonus).

  1. Set the evaluation type of all the properties evaluated in this way to “Script”.

Created in this way, the default expressions you would usually enter into each property separately, can all be combined and evaluated as a single property. The other properties are updated when the settemporary expression is evaluated, which is dependent on its own evaluation mode.


settemporary() sets the "temporary" value of a node. This means that even though you may see that value when you click on a cell or when the property in question is used in charts and pivots, it may not be persisted/hard-coded into the cell itself. This usually isn't a problem, except when your dataset contains enough expressions that you want to make use of the 'On Demand' evaluation type, because then it means you will need to recalculate every time you open your dataset.

node.setvalue() works in the same way as node.settemporary() except that it does persist the value of the expression into cells, meaning that no recalculation is needed until you actually want to refresh the values for a property.

results matching ""

    powered by

    No results matching ""