Database Reference
In-Depth Information
Figure 9-5.
Accessing databases and tables from Management Studio
In Figure
9-6
, the SSAS cube database engine and the result set is from an MDX statement. (For more
information about MDX statements, see Chapter
14
.
) The results are the same, but the user interface is a bit different.
Figure 9-6.
Accessing databases and cubes from Management Studio
SQL Server and Analysis Server are also similar when reports are made against them. In Figure
9-7
, note
how these Excel reports look alike even though one report is based upon a SQL view and the other, an SSAS cube.
Other Microsoft applications, such as Reporting Server (SSRS), smooth out the differences as well.