Database Reference
In-Depth Information
6.
In the Detail Filter Expression dialog box, create the following expression using the
Month key
query item from the
Time dimension
query subject:
[Product forecast (query)].[Time].[Month key]
IN (200505, 200506)
NOTE
We will be removing this filter after testing is complete for this query. To make sure
that the report will actually return different data, we will query on months that are similar
(May 2005) and ones that are in only one query (June 2005).
7.
Va l i d a t e t h e e x p r e s s i o n a n d c l i c k
OK
to close the dialog box.
8.
From the
Run
menu, select
View Tabular Data
to test your query. The results should
match what's shown in Figure 4.14.
Figure 4.14
Forecast query using the new model
Step 4: Build Legacy_Query
The legacy query will contain the code from the previous version of the report.
1.
In the
Explorer Bar
, hover over the
Query Explorer
tab and select the
Queries
folder.
2.
Click the
SQL
object pointing to the
Legacy_Query
query.