Create Jedox Element
jedox_create_elementCreate a single element in a Jedox dimension. Supports numeric, string, and consolidated types with optional children for rollups.
Instructions
Create a single element (member) in a Jedox dimension.
Args:
database_id: Numeric ID of the database
dimension_id: Numeric ID of the dimension
name: Element name
type: "numeric" (default), "string", or "consolidated" (parent/rollup)
children: (consolidated only) Array of { element_id, weight }
weight=1.0 means add to rollup (default)
weight=-1.0 means subtract (e.g. Costs with -1 under Profit = Revenue - Costs)
Children must already exist; provide their numeric element_id values.
Returns: { id, name, typeLabel }
For creating many elements at once, use jedox_bulk_create_elements instead.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database_id | Yes | ||
| dimension_id | Yes | ||
| name | Yes | Name for the new element. | |
| type | No | Element type: 'numeric' for data cells, 'string' for labels, 'consolidated' for parent/rollup nodes. | numeric |
| children | No | For consolidated elements: child elements and their weights. Omit for leaf elements. |