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