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>