Dimension List

Ok now we're getting into some spreadsheet magic. This tab feeds other tabs and it's important that it is filled out correctly.

On all auto populated columns, simply drag down until you have values equal to the values in column A.

Column Name

Usage

Physical Dimension Name

This is a list of all the physical dimensions used in the model. This is important because physical dimensions like DimDate that function as role play dimensions will show up more than once in this list.

Physical Dimension Key Column

This is an auto populated column.

Logical Dimension name

This is the logical name for dimensions and will be the same as column A unless it is a role play dimension.

Logical Dimension Key Column

This is an auto populated column.

Unique Row Identifier

This holds the column that this dimension uses to identify unique rows when it gets loaded. If it's a junk dimension, it will be RowHash. Most other dimensions will be SourceSystemKey except for the occasional edge case.

Row Identifier Data Type

This is an auto populated column.

Dimension Number

This is an auto populated column.

Last updated