Get Jedox Cell Range
jedox_get_cell_rangeRetrieve multiple cells from a Jedox cube by specifying dimension filter arrays. Builds a Cartesian product of filters to fetch specific cell values.
Instructions
Read multiple cells from a Jedox cube using dimension filters.
The tool builds a Cartesian product of your dimension filters to determine which cells to fetch. Keep filter arrays small to avoid exceeding max_cells.
Args:
database_id: Numeric ID of the database
cube_id: Numeric ID of the cube
dimension_filters: Array of arrays, one per dimension (in cube dimension order). Each inner array is the list of element names you want for that dimension. Example: [["Revenue","Cost","Profit"], ["Jan","Feb","Mar"], ["Total"]] → fetches 3 accounts × 3 months × 1 region = 9 cells
max_cells: Cap on total cells to return (default 1000, max 10000)
Returns: { cells: [{ path, value, type }], total }
Use jedox_get_cube first to confirm dimension order.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database_id | Yes | ||
| cube_id | Yes | ||
| dimension_filters | Yes | Array of element name arrays, one per dimension in cube order. The Cartesian product of all arrays defines which cells to retrieve. Example: [['Jan','Feb'],['Revenue','Cost']] fetches 4 cells. Keep the total cell count under max_cells. | |
| max_cells | No | Maximum cells to return. The Cartesian product of all dimension filters must not exceed this. Default: 1000. |