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) |
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.