To change the data source and/or fact table
Caution This wizard updates a partition. Incorrect use of partitions can result in inaccurate cube data. For more information, see Partitions and its subtopics in the Administrator’s Guide.
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 than those already used by the partition.
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.
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. For more information, see Fact Table Considerations when Merging Partitions.
To change the data source and/or fact table