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.
Transactional Drill Block	Runs the assigned stored procedure(s) then displays the results. See Block Event Payloads for information about what payload will be sent to these type of events.
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. See Block Event Payloads for information about what payload will be sent to these type of events.
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