Adding and removing tables for a project

As you become aware of the additional needs of report designers and users, it may become necessary to add additional tables from the data warehouse to your project. Also, as your project matures, you may need to remove tables from your project that are no longer used and are taking up space in the metadata.

You can access the Warehouse Catalog at any time to add additional tables from your data warehouse to your project and remove tables from your project.

For information on removing tables from a project that were removed from a data source, see Managing warehouse and project tables.

To add or remove tables after creating a project

1. Access the Warehouse Catalog for your project as described in Accessing the Warehouse Catalog. Log in to the project source that contains your project in MicroStrategy Developer, and expand your project.

2. The left side of the Warehouse Catalog lists all available tables and the number of rows each table contains. The list on the right shows all the tables already being used in the project:

   • To add tables: From the left side, select the tables you want to add to the Warehouse Catalog, and click > to add the selected tables. Click >> to add all the listed tables.

   • To remove tables: From the right side, select the tables you want to remove from the Warehouse Catalog, and click < to remove the selected tables. Click << to remove all the listed tables.

   • If you have the MultiSource Option, you can add tables from multiple data sources into your project. For information on adding tables from multiple data sources into your project with the Warehouse Catalog, see Accessing multiple data sources in a project.

3. In the toolbar, click Save and Close to save your changes to the Warehouse Catalog. The table definitions are written to the metadata. This process can take some time to complete.

4. Update the project schema from the Schema menu, by selecting Update Schema.