Day 4

• - Report Developers don't need to worry about the Warehouse structure
• - The Data Warehouse can contain fact columns with multiple names
• - You don't have to resolve descrepencies in the Data Warehouse

• Only Basic (Simple, Homogeneous) Facts can be created.
• Both Compound and Basic Attributes can be created with the Attribute Wizard.

It is the name and type of how the Fact will be stored in SQL Temp tables. Sometimes if there are multiple types or calculations, the alias will need to be adjusted to avoid an error.

• Compound (primary key of multiple columns)
• Homogeneous (same column names throughout)
• Heterogeneous (different column names)

• Warehouse Tables Pane
• Project Tables View Tab
• Hierarchy View Tab
• Properties Pane
• Project Objects Pane
• Menu Bar
• Toolbar