Priority Sequence Drivers

In some business models, a driver may use one or more calculated measures in the formula. Dependencies between sources in the same stage may require the allocations to be calculated in a controlled sequence. Priority sequence drivers enable you to define which allocations within a stage should be calculated first.

For example, by setting the driver priority, you ensure that Source A using Driver A is calculated before Source B, using Driver B. The cost or revenue values calculated by allocating Source A first can then be used by Driver B.

Any Level-0 descendant of the Measures dimension can be picked as a driver measure. When defining the driver, enter the Sequence Priority on the Drivers dialog box. The sources associated with drivers that have a lower priority are resolved before sources associated with a driver that has a higher priority. The default value is set to 100, but this value can be changed. The highest priority is 1. The priority must be a positive integer. Sources associated with drivers with the same priority are processed in no defined order.

If you change the priority for a driver, you are potentially changing the calculation order of sources in that stage. In that case, the calculation script for that stage must be regenerated.

Note:

For intrastage and reciprocal assignments, if the inherent sequence inside these allocations conflict with the Driver Priority Sequence, the conflicting intersections are logged to hpcm.log file.