Specify Data Source and Fact Table (Incremental Update Wizard)
In this step of the wizard, you select the data source and fact table that contain the new data to add to your partition. The data source and fact table already used by the partition are displayed by default. If they also contain the new data you are adding, click Next.
You can select a data source and/or fact table different from those already used by the partition.
Options
Data source
View the data source that contains new data for the incremental update. If you select a different data source, it must contain a fact table with the same structure and columns as the partition's fact table, and it must contain dimension tables with the same structure and columns as the partition's dimension tables. The wizard displays the required dimension tables.
Fact table
View the fact table that contains the new data for the incremental update. If you select a different table, it must have the same structure and columns as the partition's fact table. You must also manually merge the table with the partition's fact table after the incremental update completes.
Change
Click this button to open the Choose a Fact Table dialog box, where you can select a new data source and fact table.
The required dimension tables are
View a list of the dimension tables your data source must contain. If you select a different data source, it must contain fact and dimension tables with the same structure and columns as the cube's data source.