xpna.DATA FUNCTION
Usage
The DATA function is one of the two core functions in XPNA. It is used to retrieve the value of a datapoint defined by one or more members. It will return a number into a single cell.
The function expects at least one MEMBER and does not allow the use of multiple members from the same hierarchy.
This is a context-aware function, so when selected, the xpna task pane will show a Drill to transactions action button.
Syntax
| Argument | Description |
|---|---|
| member 1 | A reference to a single MEMBER cell. |
| [member2..member15] | A reference to a single MEMBER cell. (optional) |
Best Practices
xpna will retrieve the value for each DATA function when required, so it is recommended to minimise the number of DATA functions in the workbook (even if hidden). Prioritise building summary reports users can drill down into, rather than having detailed reports with many DATA functions.
Additionally, duplicating worksheets for each Department / Region / Cost Centre is not recommended, as this will lead to a large number of DATA functions in the workbook. Instead, use a single worksheet with a slicer to filter the data.
Common Problems
- The function will return an error if you do not provide at least one member.
- All members must resolve to a valid member for your workspace.