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:

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.