Most of you would be working on it w/o knowledge. Pretty nifty.
- Base table: Provides source data for metrics. In a given SQL pass, the base table(s) may be fact tables or previously calculated intermediate tables.
- Lookup table: Provides attribute IDs and descriptions. A table functions as a lookup table if its columns appear in the SELECT, WHERE or GROUP BY clauses.
- Relationship table: Includes at least two attribute ID columns to join attributes. A lookup table can serve as a relationship table, or it could serve as both a lookup and a relationship in the same query.
A table functions solely as a relationship table if it appears only in the FROM clause.
A transformation table is a special case of relationship table. - Partition mapping tables: MicroStrategy warehouse and metadata partition mapping use pre-queries to determine the physical tables to use for a particular metric. Warehouse partition mapping depends on physical tables in the warehouse, which will appear at the top of the FROM clause in the pre-query.
In Star schema, there is virtually no difference between Base Table and Lookup table.
Please let me know if there is any other type of MicroStrategy table.