List Jedox Dimension Elements
jedox_list_elementsRetrieve paginated lists of dimension elements from a Jedox database by specifying database and dimension IDs, with options for limit and offset.
Instructions
List elements (members) in a Jedox dimension, with pagination.
Args:
database_id: Numeric ID of the database
dimension_id: Numeric ID of the dimension
limit: Max elements to return (1-1000, default 100)
offset: Skip N elements for pagination (default 0)
Returns: { items: [{ id, name, type, typeLabel, level, depth, numberOfChildren }], total, offset, limit, hasMore }
Element typeLabel values:
"numeric": leaf data element (holds numbers)
"string": leaf string element
"consolidated": parent/rollup node (has children, aggregates values)
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database_id | Yes | Numeric ID of the database. | |
| dimension_id | Yes | Numeric ID of the dimension. | |
| limit | No | Maximum number of elements to return (1-1000). Default: 100. | |
| offset | No | Number of elements to skip for pagination. Default: 0. |