The OLAPData function allows simple access to a single OLAP cube cell value during a transformation process, without defining a Cube extract and a Lookup function for it.
Input consists of the cell path to the OLAP cell. The number of inputs must be identical to the number of dimensions in the cube. The ith input is an element of the ith cube dimension. It’s convenient to use constant input values.
Parameters
| Connection | A connection to a Jedox or JedoxOLAP connection |
| Cube | Name of an OLAP cube in the connection |
| Default mapping | If checked, null values in OLAP cells will be replaced with zero, if they are numeric cells, and an empty string, if the cell is any other type. |
Updated January 29, 2024