Chapter 4. SSAS Developer and Admin Interfaces

Now that you have a feeling for how Analysis Services works, you need to figure out how to work with it. In this chapter, I'll review the ways of interacting with SSAS as a developer or administrator. (I'll cover user interfaces in Chapter 14.) Three interfaces are available: Business Intelligence Development Studio (BIDS), Management Studio, and PowerShell. Of these three, BIDS is perhaps the one you'll use most often.

Business Intelligence Development Studio

BIDS was introduced as the development platform for SSAS with SQL Server 2005 and Visual Studio 2005. For SQL Server 2008, BIDS is based on Visual Studio 2008. As the business intelligence part indicates, BIDS is the development front end for ...

Get Pro SQL Server 2008 Analysis Services now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.