Input sets allow you to group a model's data sources in sets. Use the input sets as alternatives when building a cube corresponding to a model.
Each data source must belong to at least one input set, and each input set must include all necessary sources for a complete cube build.
This means you can maintain one model for a cube and build it from more than one environment. For example, with a Development input set and a Production input set, file formats or queries used to retrieve data can move from the development environment to the production environment.
This feature facilitates use of more than one input set for a single model. When you build the cube you identify the input set to use.
You can define two types of input sets:
Full |
The cube is completely built as if was the first time, regardless of the data loaded in previous buildings. |
Incremental |
The cube is built by adding the data that will be read from the indicated entry data. The designer is responsible for making sure that this set has only the data that is to be added. |
Notes
- To perform an incremental build you must define an incremental input set. Whenever you define an incremental build, an input set for a full build must also exist.<link al pane>
To define an input set:
- Select the cube's branch in the Design tree. The Properties pane for the cube displays.
- Choose the add an input set, choose the Add button in the Input Sets group box.
- To edit the input set name, double-click on the Name field.
- Enter the new input set name.
- To change the input set type, double-click on the Type field. The list of types displays.
- Select a type. The Type field updates.
Notes
- Changes made in the Property pane apply when you leave the pane or perform another operation in O3 designer.
The Input Sets definition in the cube general tab