Logical tables - Microstrategy

Logical tables are MicroStrategy objects that form the foundation of a schema. While physical tables in a data warehouse consist of columns, logical tables in the MicroStrategy schema consist of attributes and facts. These attributes and facts are part of the report definition that the MicroStrategy Engine refers to when a report is executed.

There are three types of logical tables:

  1. Logical table: is created for each physical table that is imported into a project, using the Warehouse Catalog. This type of logical tables maps directly to physical tables in the data warehouse. These physical tables are referenced in the SQL that is generated for the report.
  2. Table alias: is created outside of the Warehouse Catalog and points directly to a physical table. A table alias can have a different name from the physical table. One physical table can have more than one table aliases. Table aliasing is used to create attribute roles.
  3. Logical view: does not point directly to a physical table and is defined using a SQL query against the warehouse. bOnce created, the logical view can be used in the same wayas the Type 1 logical table, based on which attributes, facts, and other schema objects can be defined. The logical view is also referenced in the SQL that is generated for the report; the whole SQL query is displayed in the place of physical tables as for Type 1 logical tables. Logical views are created using the Table Editor.

Using the Table Editor, you can view the content of all the logical tables as well as their associated warehouse tables. In the MicroStrategy Tutorial, logical tables and all the other schema objects are stored in the Schema Objects folder.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Microstrategy Topics