Version 2021
Tables
No PostgreSQL specific customizations were made for this feature.
Logical tables are MicroStrategy objects that form the foundation of a schema. Physical tables in a data warehouse consist of columns, and logical tables in the MicroStrategy schema relate this column data to attributes and facts. These attributes and facts are part of the report definition that the MicroStrategy Engine refers to when a report is executed.
The types of logical tables are:
- Logical table: A logical representation of a physical table that MicroStrategy uses to generate SQL. This type of logical table maps directly to physical tables in the data warehouse.
- Logical table alias: A logical table that uses a different name for a physical table. One physical table can have more than one logical table alias. Logical table aliases are used to create attribute roles.
- Logical view: A logical table that is created using a SQL statement instead of being a direct representation of a physical table. Once created, the logical view can be used in the same way as any logical table.
How to Create Logical Tables
Logical tables are brought into the project by using Warehouse Catalog or Architect, and table aliases are created by duplicating existing logical tables. Logical views can be created in MicroStrategy Developer using the Table Editor.
See Logical Tables and Creating Logical Views for more information.