Skip to content

Cube Event Types

The following is a list of the Cube Event types that can have SQL stored procedures wired up:

Event Name Description
Transactional Drill Runs the assigned stored procedure(s) then displays the results. See Transactional Drill
Transactional Drill – Block Runs the assigned stored procedure(s) then displays the results. See Transactional Drill
Writeback – Before Block Runs the assigned stored procedure(s) before the block of data is processed. These procedures run once per writeback batch.
Writeback – Before Cell Runs the assigned stored procedure(s) before each data point is processed. For example, if you input ten numbers, then this process would run ten times; once for each number in the writeback batch.
Writeback – Write Cell Runs the assigned stored procedure(s) as each data point is about to be written. The following behaviours apply. (see: Writeback - Write Cell - Behaviours below)
Writeback – After Cell Runs the assigned stored procedure(s) after each data point is processed.
Writeback – Write Block Runs the assigned stored procedure(s) for all data points at the same time.
Writeback – After Block Runs the assigned stored procedure(s) after the block of data is processed.

Note: If you have stored procedures wired up for Write Cell and Write Block, they will both execute, with the Write Cell all firing before the Write Block

Writeback - Write Cell - Behaviours

Data Writeback

When a data point (with stored procedures assigned to it) is being processed, the stored procedures are executed instead of performing the native SSAS update for the data point

Note Writeback

When a text note (with stored procedures assigned to it) is processed, the stored procedures are executed as well as performing the note writeback