Database Reference
In-Depth Information
A classic way to use a diagramming tool is to document your table designs using the Excel spreadsheet
and then use the worksheet to create the new tables, much as a carpenter uses a blueprint to build a house.
As you can see in Figure
5-28
, we created a new fact table while having both the diagramming tool and an
Excel spreadsheet open.
Figure 5-28.
Using a BI solution plan as a blueprint