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
||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.