Database Reference
In-Depth Information
Create a report with the report Wizard
1.
using the visual Studio menu, select the File
➤
Add
➤
New Project option. The Add
New Project dialog window appears.
2.
Select the Business intelligence option on the left side of this window and the Report
Server Project wizard on the right side (Figure
2-62
).
3.
Locate the Name textbox and change the name to
WeatherTrackerReports
. verify
that this project will be created in the
C:\_BISolutions\WeatherTrackerProjects
folder (Figure
2-62
).
4.
Click OK to close the dialog window. You should see the new SSRS project added to
your solution in Solution Explorer, and the Report wizard welcome screen will appear.
5.
You can read what is on this page or just click Next to move to the next page (Figure
2-63
).
6.
The next page of the wizard is the Select the Data Source page. Change the value in
the Name textbox to
WeatherTrackerCubes
.
7.
Locate the Type dropdown box and use it to select Microsoft's SQL Server Analysis
Services connection type (Figure
2-63
).
8.
Locate the Edit button and click it to bring up the Connection Properties dialog
window.
9.
when the Connection Properties dialog window appears, type in the name of your
SSAS server in the “Server name” textbox. This is usually your computer name,
localhost or the word (local) with parentheses; then click OK (Figure
2-63
).
10. Click Next to go to the next page of the Report wizard dialog window (Figure
2-64
).
This page, called Design the Query, allows you to create SQL, MDX or DMX queries
using a query-building tool. Click the Query Builder button. MDX is the language
used to query Analysis Server cubes, so clicking this button will bring up an editing
tool that creates MDX code, and the Query Designer dialog window will appear
(Figure
2-64
).
11. On the left side of this dialog window is a representation of the DwweatherTracker
cube. Click the + symbol to expand the Measures, and then click the Fact weather
treeview icons.
12. Locate the Max Temp F icon. Drag this icon to the center of the dialog window. This
measure is displayed as a representation of the report data.
13. Locate the Min Temp F icon. Drag this icon to the center of the dialog window. This
measure is also displayed as a representation of report data.
14. Locate the Event icon directly under the DimEvents icon. Drag this icon to the center
of the dialog window. This dimensional attribute is now displayed along with the
measures.
15. Locate the EventDate icon directly under the DimDate icon. Drag this icon to the
center of the dialog window. This dimensional attribute is now displayed as well.
