Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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 folder.

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

...