Write back to OLAP

To write back notes to OLAP:

  1. In a text editor, specify the XML to write back text that is entered in the web extension. Text is written to the NoteReporting property of OLAP. Use this syntax: 
    =CELLPROPERTYWRITE(
SETPROPERTY(
SETPROPERTY(
CELLPROPERTYGET("noteReporting","data_connection","cube", dim1, dim2,..),
"FormattedNote","content",GETPROPERTY(actions.input.text,"FormattedNote","content")
),
"PlainNote","content",GETPROPERTY(actions.input.text,"PlainNote","content")
),
"NoteReporting","data_connection", "cube", dim1, dim2,...)
  2. Edit the action in cell A11. Click Add parameter and select No target. In the Edit Value dialog, paste the prepared XML as the value of the new parameter.
  3. Replace the content of cell A11 with this function:
    =GETPROPERTY(CELLPROPERTYGET("noteReporting","data_connection","cube", dim1, dim2...), "FormattedNote","content")
  4. Click OK.
  5. View the report in a web browser.