What's New in Analysis Services and Business Intelligence
Topic Status: Some information in this topic is pre-release and subject to change in future releases. Pre-release information describes new features or changes to existing features in Microsoft SQL Server 2014.
With exception to added functionality supporting Power View Reports against Multidimensional Models, SQL Server 2014 Analysis Services is unchanged from the previous release.
For information about other SQL Server 2014 products and technologies that are different in this release, see What's New in SQL Server 2014.
SQL Server Data Tools for Business Intelligence (SSDT BI), previously known as Business Intelligence Development Studio (BIDS), is used to create Analysis Services models, Reporting Services reports, and Integration Services packages. In this pre-release version of SQL Server 2014, SQL Server Setup no longer installs SSDT BI. The Visual Studio 2012 version of SSDT BI is now available as a web download from the Microsoft Download center.
If you have a prior version of SSDT BI or BIDS installed on your computer, the newer version is installed side-by-side the previous version. It's common to run newer and older versions of the design tools on a single workstation so that you can modify projects and solutions tied to specific versions of the server.
There are several download sites for the Visual Studio 2012 version of SSDT. Some downloads do not include the BI project templates. Using the link previously provided will get you the correct version. You know that you have the correct version of SSDT if you see the Business Intelligence project templates folder. This folder contains the project templates for Analysis Services, Reporting Services and Integration Services. Depending on how you installed SSDT, you might also see an additional project template for SQL Server databases.
The ability to create Power View reports against multidimensional models was first introduced in SQL Server 2012 Service Pack 1 Cumulative Update 4. Power View for Multidimensional Models functionality is now included as part of SQL Server 2014.
Power View Report for a Multidimensional Model
This functionality helps organizations maximize existing BI investments by enabling multidimensional models (also known as OLAP cubes) to be used with the latest client reporting tools. Depending on the types of data in the multidimensional model, users can easily create a variety of dynamic visualizations from tables and matrices, to bubble charts and geographical maps. Multidimensional models now also support queries using Data Analysis Expressions (DAX).
Power View for Multidimensional Models requires the built-in Power View reporting capability in SQL Server 2014 Reporting Services (in SharePoint mode). Other versions of Power View, specifically the Power View Add-in in Excel 2013, do not support multidimensional models.
To learn more, see Power View for Multidimensional Models.