Creating aggregate tables

You can integrate aggregate tables in your project using the Warehouse Catalog in MicroStrategy Developer, as outlined in the following procedure.

To use an aggregate table in an existing project

1 Using the Warehouse Catalog, add the table to the project. For steps to add tables using the Warehouse Catalog, see Adding and removing tables for a project.
2 Use the new table in the desired fact expressions and attribute form expressions.

If your aggregate table structure is consistent with your base fact table structure, Architect automatically adds it to the definitions of your existing attributes and facts. In other words, Architect is aggregate-aware. How does Architect know to use the aggregate table rather than the base fact table, when either could provide the answer to a query? The answer is logical table size.