Create a dimension key in Shared Dimension step

Pentaho Data Integration
Version
9.3.x
Audience
anonymous
Part Number
MK-95PDIA003-15
To use a shared dimension, you will need to designate one annotation in the Shared Dimension step as the dimension key. Since you can create multiple annotations on the same field, you can use a selected field as an annotation and as the dimension key. For example, you might want to create an attribute and a dimension key on the field Year in your time dimension.
  1. If you have not done so already, complete steps 1-8 of Create a shared dimension.
  2. Select Create Dimension Key from the Actions menu.
    The Name - Value table auto-populates with the Dimension attribute.
    Create dimension key
  3. Enter or select a dimension in the Value field for Dimension. The selected field will be used as the key for this dimension.
  4. Click OK to finish or click Cancel to exit.
    In the Shared Dimension dialog box, the selected field will now appear with the summary that it is the key for the shared dimension. For example, the field 'Calendar Year' may display 'Calendar Year is key for dimension Year' in the Summary column.
    Shared Dimension with Calendar Year
You can use a single field more than once, so you will be able to use the field you selected here for both the key and to create annotations.