Downloads for Data Warehouse Designers

Dimensional Matrix

Extended Dimensional Matrix (XLS)

Excel workbook for planning and documenting a dimensional data warehouse.  Contains blank examples of logical and physical dimensional matrices together with several other spreadsheets for capturing data warehousing requirements.
 

Variable Depth Hierarchies

Example Company table with recursive relationship, sample data illustrating a variable depth hierarchy and Hierarchy Map table definition (SQL)

Example Oracle Procedure for Populating a Hierarchy Map table (PL/SQL)

The example procedure will take the 27 related companies in the Company table and load 110 parent-subsidiary relationships into the Company Structure hierarchy map.

To view the example company relationships graphically click here
 

Aggregate Management

Aggregate Planner (XLS)

Excel pivot table for planning a portfolio of aggregates.  Calculates sparsity failure and performance improvement for each aggregate.  Allows visualisation of aggregate spread for the whole warehouse or individual fact tables.