User Experience Enhancements (SSAS)

Microsoft SQL Server 2005 Analysis Services (SSAS) includes the following user experience enhancements and new features.

Business Intelligence Development Studio

Analysis Services is fully integrated with the Microsoft Visual Studio 2005 development environment for creating end-to-end business intelligence solutions. You can use BI Development Studio to create and maintain Analysis Services components, such as relational data source, OLAP, and data mining objects. For more information about BI Development Studio features, see New Business Intelligence Development Studio.

SQL Server Management Studio

SQL Server Management Studio is a fully integrated management environment for administrators and developers, replacing the functionality of Analysis Manager in earlier versions of Analysis Services. You can use Management Studio to manage instances of Analysis Services, to browse and administer Analysis Services databases and objects, and to develop, execute, and analyze Multidimensional Expressions (MDX), Data Mining Extensions (DMX), and XML for Analysis (XMLA) queries and scripts. For more information about Management Studio features, see New SQL Server Management Studio.

Analysis Services Wizards

Analysis Services wizards have been redesigned for the development environment provided by BI Development Studio. These wizards let you quickly create or enhance Analysis Services objects such as data source views, dimensions, cubes, and data mining models. Additionally, new wizards have been added to Analysis Services to support new features like deployment. For more information about the new and enhanced wizards in Analysis Services, see New Analysis Services Designers and Wizards (SSAS).

Analysis Services Templates

Analysis Services provides templates in BI Development Studio for Analysis Services objects such as cubes, dimensions, Key Performance Indicators (KPIs), calculated members, named sets, calculated cells, actions, Multidimensional Expressions (MDX) statements, and Data Mining Extensions (DMX) statements. Analysis Services also provides templates in SQL Server Management Studio for MDX and DMX queries and statements. Templates are stored in an XML-based format, which lets you easily define and create additional templates.

See Also

Other Resources

Analysis Services Enhancements (SSAS)

Help and Information

Getting SQL Server 2005 Assistance