Database Reference
In-Depth Information
18. Switch to Diagram view and drag the
ProductCategoryKey
column from the
DimProductSubcategory
table and drop it on the
ProductCategoryKey
column of the
DimProductCategory
table.
Now you have added information from a database, from a text file, and from a report
and you have seen the capabilities that the tabular model has when it comes to
mashing up data from different data sources. However, it is still recommended that
you have a data warehouse for the reasons described in
Chapter 3
,
Creating Your
First Multidimensional Cube
.
Search WWH ::
Custom Search