NSET

You can attach comments to particular cells of an OLAP Server cube (for example, to explain unexpected sales results). You can attach comments to every cell of the cube.

NSET attaches text in a specified worksheet cell as a note to the specified OLAP Server cube cell. Entering text in a cell containing this function attaches the text as a cell note.

Syntax

NSET(Value,Database alias,Cube,Element1...Elementn)

Value is the text to send to the cube cell, Cube is the cube containing the cell to which the note is attached and Element1...Elementn are elements from each of the dimensions in the cube. Element1 must be from the first dimension in the cube, Element2 from the second and so on i.e. the sequence of the elements must reflect the sequence in which the dimensions for the cube were defined.

Arguments to this function can be strings, or references to cells containing strings. If strings, they must be enclosed in quotes.

If an element does not exist or is not a member of Dimension, the function returns a #Value error.