Description
Returns all elements in a dimension. This step can return base elements only or return all levels of a dimension.
Note: As a prerequisite, you need to place the palojlib-x.x.x.jar into the /lib folder. The library (palojlib) is included in the Jedox installation, and is also available as part of the Jedox SDK.
Options
Option | Description |
|---|---|
Step Name | Name of the step; the name has to be unique in a single transformation |
Connection | The Palo connection to use |
Dimension | Dimension to fetch elements for |
Base Elements Only | If selected, only returns base elements. Only one level is returned when the 'Get Levels' button is selected |
Field list | List of levels and their associated field names |
Get Levels | Auto populates the field list with all levels of the specified dimension. If "Base Elements Only" is selected, only one level is returned. |
Clear Levels | Clears the field list. |
Field list
The field list specifies output field names to use for each level.
Option | Description | Read Only |
|---|---|---|
Level Name | Auto generated level name | Yes |
Level Number | Auto generated level number | Yes |
Field | Field name that will hold the data | No |
Type | Must be String or Numeric. | No |