The ‘Procedural Block’ tab presents an edit window that allows the input of an Oracle anonymous block. If there is anything in this window it will be actioned instead of the statement. A button in the lower right allows a rudimentary template block to be built. If used this block must do the actual insert statement rather than just the select. It must also handle ALL dimension, month to date measure and non standard columns. In addition, it will need to put default values in columns not actively being updated. The KPI dimension and date dimension keys must also be updated. The output from a ‘View Statement’ option for another KPI will give an indication of what the block must do. The same month last year, year to date and previous year to date measures will still be handled automatically. The same $KPI_ variables as shown above the statement edit window can and must be used.