Description
This step creates new dimension elements and consolidations if they don't exist. It also updates existing consolidation factors. All rows needs to be read before updates take place since all rows are needed to calculate consolidations.
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 |
Create New Dimension | If the dimension doesn't exist, it will be created. If it does exist, this option is ignored. |
Recreate Dimension Before Load | Drops and recreates a dimension before load. It is a quick way to clear the dimension as deleting all elements from a dimension can be slow depending on how |
Clear Dimension Before Load | Deletes all elements from a dimension. This can be slow for large dimensions. |
Clear Consolidated Elements Before Load | Deletes all consolidated elements before a load. Useful to recreate consolidations only. |
Enable Cache | Dimension element lookups are stored in local cache for reuse in subsequent lookups. |
Pre-load Cache | Loads all dimension elements into local cache before the load starts. |
Dimension | The dimension to load |
Default Element Type | String/Numeric. Default element type for each element. |
Field list | Maps input fields to update dimension elements and consolidations. |
Get Current Level | Populates the current field list |
Clear Levels | Clears the field list |
Field List
Field specification to update dimension elements and consolidations. Lower levels are consolidated into parent levels with the specified consolidation factor. All elements at Level 2 will be consolidated into elements at Level 1 etc.
Option | Description | Read Only |
|---|---|---|
Level Number | Level number | Yes |
Level Name | Name to give the level | No |
Field | Input field to update the level | No |
Consolidation Factor | Input field to specify the consolidation factor with parent levels. | No |