Database Reference
In-Depth Information
A data source view can also be used to combine data from different data sources.
This means that you can fetch data from several databases.
This brings up the question, do you really need a data warehouse in the first place?
As described earlier in the chapter, one of the beneficial things with a data ware-
house is to keep a history of data that will survive changes in the source systems.
If you connect Analysis Services directly to the operational source systems, you will
not be able to keep the history if one of the source systems is changed. In addition
to this, you will have the issues of reporting load on the OLTP system, you will work
against a schema that is non-optimal for BI use, and so on.
All Analysis Services objects use the data source view as their data source, this
means that everything that other objects need access to need to be added to the
data source view.
Creating a new data source view
Tocreate adata source view against the
AdventureWorksDW2012
connection, you
need to follow these steps:
1. Right-click on the
Data Source Views
folder in the
Solution Explorer
win-
dow.
2. Choose to create a new data source view and click on the
Next
button.
3. Specify that you want to use the data source that you created in the earlier
step as the source and click on
Next
.
4. Select to add the following tables to your data source view:
•
FactInternetSales
•
DimSalesTerritory
•
DimProduct
•
DimDate
•
DimCustomer
•
DimPromotion
•
DimProductSubcategory
Search WWH ::
Custom Search