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.
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