SetInstruction ^v2.11.0

The SetInstruction formula makes a cell in Excel interactive. When double clicked, it prompts the user to select an element from a list, based on predefined set instructions. This functionality can be configured through the Create/Edit Formula Wizard or directly by typing the formula.

SetInstruction(applicationName, dimension, instructions, selection)

Parameters

• applicationName - The name of the application through which to access the model.
• dimension - The dimension for which the set of instructions applies.
• instructions - A list of instructions defining the context and behavior to provide a list of elements.
• selection - The current selected element.

Example

SetInstruction("Sales Application", "Product", {"set|All Products", "expand-all", "drill-down"}, "All Products")

Notes

• You can use Excel cell references within the instructions parameter. For example:

  SetInstruction("Sales Application", "Product", {"set|Excel(A1)", "expand-all", "drill-down"}, "All Products")

  In this case, the value of cell A1 will replace Excel(A1) in the instructions.

• Additionally, you can use a range of cells. For example:

  SetInstruction("Sales Application", "Product", {"set|Excel(A1:A5)"}, "All Products")

  Here, all values in the range A1:A5 will be included as part of the set for the instruction.