Destination Stages

Cube Insert Stage

This stage allows you to insert your data into a cube.

To add a Cube Insert stage to your pipeline

1. With your pipeline in Edit mode filter out the Stage library, by selecting Destinations, to display only the destinations stages.
2. In the stage search box, start to type cube and select the Cube Insert stage from the filtered list. The Cube Insert stage is added to your pipeline.

Fig. 26: The Cube Insert destination configuration.

Notes

• The options available for the Create report field are:
  • IF_DOES_NOT_EXIST: creates the associated report only if it does not exist. Otherwise, it keeps the existing report unmodified. This is the default option.
  • NEVER: it does not create the associated report. You must create it manually.
  • ALWAYS: it always creates an associated report. If you select this option and you have a report with custom attributes, you will loose those attributes.
• The Key Fields group of options allow you to select only a subset of the source data stream to insert into the cube. Additionally, you have the option to rename those field, by setting a Destination Column Name.
• The Generate missing columns option allows you to control how to import the rest of the fields that you didn’t add to the Key Fields group. Select this option to import all the remaining fields, or keep it unselected if you don’t want to import them.