Database Reference
In-Depth Information
The
Date
dimension is what is called a role-playing dimension. In this example, you
have three different dates in the
FactInternetSales
table all with a foreign key
to the
DimDate
table. This means that the single
Date
dimension will play the role
of
Ship Date
,
Order Date
, and
Due Date
. This can be seen under
Dimension
Usage
tab in the cube editor.
During the next step, we will create additional dimensions and add them to the cube.
Search WWH ::
Custom Search