Database Reference
In-Depth Information
Figure 15-10.
Choosing fields for your report
In the next exercise, you get a chance to try it yourself.
exerCise 15-1. Creating a sQl VieW report
Use the steps within this chapter to connect to the data warehouse and build a report that looks like the one
shown in figure
15-11
.
Creating the sQl Views and stored procedures
Before we make the Excel report, let's make sure that all of the views and stored procedures needed for this
chapter are present in the database.
1.
open sQl server Management studio 2012. You can do so by clicking the start
button and navigating to All Programs
➤
Microsoft sQl server 2012
➤
sQl server
Management studio. Right-click sQl server Management studio 2012, and click
the Run as Administrator menu item. if the UAC message box appears asking, “Do
you want the following program to make changes to this computer?” click Yes (or
Continue depending upon your operating system) to accept this request.
2.
with Management studio open, choose the Connect to the Database Engine option
in the server Type dropdown box. Then click Connect.
3.
Use the file
➤
open
➤
file menu option to open the file that contains all the sQl
code needed to create the views and stored procedures for this chapter, called
C:\_BookFiles\Chapter15Files\ViewsAndStoredProceduresForChapter15.sql
.
4.
when the file opens in sQl server Management studio, execute the code using the
“! Execute” button on the toolbar.
5.
Close sQl server Management studio. we will no longer need it for this chapter.
