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