Data Collection #
Reportworq supports a function that is used to “writeback” data into Anaplan. These formulas are only available and executed when Reportworq receives a file for processing using a Reportworq Data Collection license.
ANAPLANINPUT #
The ANAPLANINOUT formula provides the ability to write a value back to an Anaplan cube. The ANAPLANINOUT formula is typically defined in an Excel report that is generated as an input template by Reportworq to collect data from users who, for instance, need to only provide minor updates to a portion of a cube.
Syntax
ANAPLANINOUT( Input Row, Input Column, Input Value )
| Parameter | Description |
| Input Row | The index of the row being updated. |
| Input Column | The index of the column being updated. |
| Input Value | The value to update at this Input Row and Column location. |