Database Reference
In-Depth Information
3. The next screen allows a user to select the creation method. Analysis Ser-
vices allows a user to build a cube without having any tables in the data
source. This can be a good way of designing a new data warehouse or data
mart. In that case you should select to generate the table in the data source.
In the example, you have a table that you want to bind the dimension to.
Choose
Use an existing table
and click on
Next
.
4. Now it is time to choose the data source view and main table that you want
to use in the dimension. The first dimension that we will create is the
Time
dimension. Choose the
DimDate
table.
Key column
in this case should be
DateKey
.
Search WWH ::
Custom Search