Database Reference
In-Depth Information
The
DATA
command tab
The
Get External
Data
drop-down
gallery arrow button
The
Get External
Data
gallery
The
From Other
Sources
button
The
From SQL
Server
button
(a)
The Get External Data Command
The
Data
Connection
Wizard
dialog box
The
Connect to
Database Server
page
Enter the SQL
Server 2012
server name here
Select the
Use
Windows
Authentication
radio button if
necessary
The
Next
button
(b)
The Data Connection Wizard Dialog Box - Connect to Database Server Page
Figure 12-21
OLAP Reports
We generated the OLAP report in Figure 12-21( j) by using a simple SQL query (run using
the Microsoft PowerPivot for Microsoft Excel add-in) and Microsoft Excel, but many DBMS
and BI products include more powerful and sophisticated tools. For example, SQL Server
includes SQL Server Analysis Services.
4
It is possible to display OLAP cubes in many ways
4
Up to this point in this topic, we have been able to do everything in this topic using SQL Server 2008 R2
Express. Unfortunately, SQL Server Express Edition does not include SQL Server Analysis Services, so you will
have to use the SQL Server Standard Edition or better if you want to use the SQL Server Analysis Services.
Although OLAP reports
can
be done without SQL Server Analysis Services, Server Analysis Services adds a lot
of functionality, and the Microsoft SQL Server 2008 Data Mining Add-ins for Microsoft Office 2007 (used in this
text) will not function without it.
Search WWH ::
Custom Search