...
Returns all elements in a dimension. This step can return base elements only or return all levels of a dimension.
Note: Within PDI 5.0, please download PaloJLib v1.0.73 from the Pentaho artifactory: http://repository.pentaho.org/artifactory/repo/palo/palojlib/1.0.73/palojlib-1.0.73.jar and place it into the /lib folderAs 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. |
...