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