You’ll build a cube in SSAS, which gives you high-speed multidimensional analysis capability. This is one of the most advanced examples in the book, so get ready for some fun. Try It Out: Creating an SSAS Project in SSDT In addition to the work you’ll do with SSDT in this chapter, you will also visit it some to work with Reporting Services, Integration Services, and more Analysis Services in the chapters ahead.
The SQL Server Data Tools is a different work area that is highly developer- (rather than administrator-) focused indeed, it is a form of Visual Studio that just has project templates oriented around many of the “extra” services that SQL Server offers. Note that SSDT is entirely different from the SQL Server Management Studio that you’ve been mostly working with thus far. NOTE: For this example, you’ll be working within the SQL Server Data Tools, or SSDT. Once you’ve had a chance to poke around there, you can take a look at some of the other ways of providing BI reporting. You can get a feel for what it takes to use SQL Server Analysis Services by building a cube based on the AdventureWorks data warehouse. For Source Code, Sample Chapters, the Author Forum and other resources, go to the book’s homepage on Ed’s Note: This is an extract from the book Beginning Microsoft SQL Server 2012 Programing by Paul Atkinson and Robert Vieira copyright John Wiley & Sons 2012.
0 kommentar(er)
