Optimizing and Maintaining Your Project » Data warehouse and project interaction: Warehouse Catalog

Data warehouse and project interaction: Warehouse Catalog

This section discusses how the Warehouse Catalog can control the interaction between the data warehouse and the database instance for a project. The Warehouse Catalog queries the data warehouse and lists the tables and columns that exist in it. From this list, you can select the tables to add to your project. Every project can have a unique set of warehouse tables.

You can add warehouse tables to your project with the Warehouse Catalog or Architect. The Warehouse Catalog is well-equipped at maintaining the warehouse tables used for an existing project. For information on Architect, see Creating a Project Using Architect.

This section also discusses customizing catalog SQL statements, the structure of the SQL catalogs, and the default SQL statements used for each database.

This section covers the following topics:

Before you begin using the Warehouse Catalog
Accessing the Warehouse Catalog
Adding and removing tables for a project
Managing warehouse and project tables
Modifying data warehouse connection and operation defaults
Customizing catalog SQL statements
Troubleshooting table and column messages
You can also add tables to a project using MicroStrategy Query Builder. For more information on Query Builder, see the MicroStrategy Advanced Reporting Guide.
You can connect to MDX Cube sources such as SAP BI, Hyperion Essbase, and Microsoft Analysis Services instead of a relational database. In this case, the MDX Cube Catalog handles tasks similar to the Warehouse Catalog. For more information, refer to the MicroStrategy MDX Cube Reporting Guide.