Wednesday, December 11, 2013

SQL Server Data Tools 2012 Downloads

Download SSDT for Visual Studio 2012 and SSDT-BI for Visual Studio 2012
http://msdn.microsoft.com/en-us/data/hh297027

You only get the SQL Server Database Project when you install SSDT for Visual Studio 2012.  Install SSDT-BI for Visual Studio 2012 to get the Analysis Services, Integration Services and Reporting Services project types.

Download Team Explorer for Visual Studio 2012
http://www.microsoft.com/en-us/download/details.aspx?id=30656

Sunday, November 10, 2013

PerformancePoint designer 2013 SSRS report issue caused by Aug 2013 CU

http://support.microsoft.com/kb/2881349

This bug prevents adding an SSRS report to a PPS dashboard after installing the August 2013 SharePoint CU.  The workaround is to only develop the cascading PerformancePoint filters in PerformancePoint Designer and the rest of the solution should get pieced together inside a SharePoint page using the Web Part connections features.

Reference: http://sqlmag.com/blog/building-real-world-microsoft-bi-dashboards-today