Hitachi Vantara Pentaho Community Wiki
Child pages
  • Palo Dimension Input (Deprecated)
Skip to end of metadata
Go to start of metadata

Description

Returns all elements in a dimension.  This step can return base elements only or return all levels of a dimension.

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

Field list

The field list specifies output field names to use for each level.

Option

Description

Read Only

Level Name

Auto generated level name

Yes

Level Number

Auto generated level number

Yes

Field

Field name that will hold the data

No

Type

Must be String or Numeric. 

No

  • No labels