Database Reference
In-Depth Information
Figure 4.12
Completed query audit report
The following steps describe the process of designing the two queries that will be joined together
and generating the report that displays the results of the comparison.
Step 1: Start the Report
1.
Launch
Report Studio
and select the
GO Data Warehouse (query)
package.
2.
Click on the
Create new
option.
3.
Select the
List
report template and click
OK
.
We will be using the
Product forecast (query)
namespace inside the
Sales and Mar-
keting (query)
folder.
Step 2: Set Up Report Queries
This step details the steps to create a main query that consists of a join between two other queries.
The first query in the join is based on the SQL from the original report. The second one is based
on the new data model.
1.
In the
Explorer Bar
, hover over the
Query Explorer
tab and select the
Queries
folder.
2.
Rename
Query1
to
Main_Query
.
3.
Drag a
Join
object from the
Insertable Objects
pane and place it to the right of the
Main_Query
.