From the course: Implementing a Data Warehouse with Microsoft SQL Server 2012

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Using Reporting Services with a data warehouse

Using Reporting Services with a data warehouse - SQL Server Tutorial

From the course: Implementing a Data Warehouse with Microsoft SQL Server 2012

Start my 1-month free trial

Using Reporting Services with a data warehouse

“

I'd like to talk about using SQL Server Reporting Services to create reports against our data warehouse. I'm going to demonstrate creating a basic report. I'd like to base that report on a View, so first we'll need to go create the View in the data warehouse. Using SQL Server Management Studio, I'll connect to the local instance. Now open up the AdventureworksDW2012 database. Have the code already staged for you to create the View. It's in your exercise folder. It's called Reporting. And I'll copy and paste all of that over. Before we run this, lets look at this code briefly. Basically, I am taking data from one fact table and three dimension tables. So the fact table is the internet sales. The dimensions are customer, geography and product. I'm pulling interesting information about all three of those dimensions. In the FROM section, we see the JOIN, so we're joining FactInternetSales onto the three dimension tables. And at the very bottom we have a WHERE clause limiting us to one…

Contents