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 |