Skip to content

Writeback Parameter Options

When wiring up Cube Events, depending on the type of event, certain parameter types will be available to use.

In a normal (non block) event type, their are assigned into each parameter from the stored procedure that is referenced.

In block event types, as many parameters as required can be created. They require a unique name and assignment to one of the available options.

Parameter Type

Datapoint

This option will send all the Member Uonque Id’s that represent the datapoint being acted on as this parameter.

Valid for:

  • Transactional Drill
  • Transactional Drill Block
  • Writeback Before Block
  • Writeback Before Cell
  • Writeback Write Cell
  • Writeback Write Block
  • Writeback After Cell
  • Writeback After Block
  • Writeback Before Cell

Hierarchy

This option allows the selection of a hierarchy to associate with a parameter.

An MDX property can also be assigned. By default, MEMBER_KEY is used, although any valid MDX is usable here.

Valid for:

  • Transactional Drill
  • Transactional Drill Block
  • Writeback Before Cell
  • Writeback Write Cell
  • Writeback Write Block
  • Writeback After Cell
  • Writeback Before Cell

New Value

This option allows the specification that the value the user entered should be mapped to this parameter. The parameter should expect a numeric value entered by the user.

For the Writeback Write Block event type, this is always passed in when a data value is written back, see Block Event Payloads

Valid for:

  • Writeback Before Cell
  • Writeback Write Cell
  • Writeback After Cell

New Value Text

This option allows the specification that the text the user entered should be mapped to this parameter. The parameter should expect a text value entered by the user.

For the Writeback Write Block event type, this is always passed in when a note is written back, see Block Event Payloads

Valid for:

  • Writeback Before Cell
  • Writeback Write Cell
  • Writeback After Cell

User ID

This option sends the user ID to a stored procedure parameter.

For block event types, this is always passed in, see Block Event Payloads

Valid for:

  • Transactional Drill
  • Writeback Before Cell
  • Writeback Write Cell
  • Writeback After Cell
  • Writeback Before Cell