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.

Note
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.

To define an input set

1. Select the cube's branch in the Design tree. The Properties pane for the cube displays.
2. Choose the add an input set, choose the Add button in the Input Sets group box.
3. To edit the input set name, double-click on the Name field.
4. Enter the new input set name.
5. To change the input set type, double-click on the Type field. The list of types displays.
6. Select a type. The Type field updates.

Assigning Data Sources to Input Sets

Use the InputSets page of the Data Sources property pane to assign a data source to an input set.

To assign a data source to an input set:

1. Select the data source's branch in the Design tree. The Properties pane for the data source displays.
2. Choose the InputSets page. A list of input sets displays.
3. Turn on the checkbox for each input set to include the data source in.

Note
Data sources include text data, SQL queries and guards.
You must define the input set for the cube before you can assign a data source to it.
Each data source must belong to one or more input sets.
You must assign at least one data source to each input set. If you do not assign an input set, the Full input is is the default during the build.
You must explicitly save the cube definition, otherwise changes apply only to the opened model.