...
This step exports all cell data in a cube. It currently returns rows for base elements only, doesn't take rules into account and skips null values. It must include all dimensions.
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 SDKr.
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 |
Cube | Cube to export data for |
Measure Name | Output field name that will hold the cell value |
Measure Type | Number or String. Data type of the cell value |
Field List | List of output field names that will hold dimension base elements |
Get Dimensions Button | Populates the field list with dimensions for the specified cube |
Clear Dimensions Button | Clears the field list |
...