MICROSTRATEGY TUTORIALS

Physical warehouse schema
The physical warehouse schema is based on the logical data
model. It is a detailed graphic representation of your business
data. It organizes the logical model in a method that makes
sense from a database perspective.
While the logical data model tells you what facts and
attributes to create, the physical warehouse schema tells you
where the underlying data for those objects is stored. The
physical warehouse schema describes how your data is stored
in the data warehouse.
Two key components make up the physical warehouse
schema—tables and columns. Columns and tables in the
physical warehouse schema represent facts and attributes
from the logical data model. The rows in a table represent
attribute elements and fact data.