To change the data source and/or fact table
Caution It is possible to create partitioned cubes that contain incorrect 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 for your partition. The data source and fact table used by the cube are displayed by default. If they also contain the data for your partition, click Next.
You can select a data source and/or fact table different than those used by the cube.
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. The wizard displays the required dimension tables.
If you select a different fact table, it must have the same structure and columns as the cube’s fact table
To change the data source and/or fact table