Database Reference
In-Depth Information
7. Click on
Finish
to create the time intelligence calculations.
What the wizard does is that it first of all redefines the Data Source View and
changes the
DimDate
query to contain a new calculation. In our case, as the
date
table actually is bound to a query, this will fail. In order to fix this, you need to perform
the following changes:
1. Double-clickonthe
Adventure Works DW2012.dsv
DataSourceViewinthe
Solution Explorer
.
2. Right-click on the
DimDate
query in the designer and choose the
Edit
Named Query
option.
3. Change the query to the following statement:
Search WWH ::
Custom Search