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: 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 SDKr.
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 |
Specifies the output field names and data types that dimension elements will be stored in
Option | Description | Read Only |
|---|---|---|
Dimension | Dimension name of a dimension in the Cube | Yes |
Field | Output field name that will hold dimension base elements | No |
Type | String/Numeric. Data type of the output field | No |