Pinned filters and URL parameters in Power View

In addition to adding support for Power View with multidimensional BI Semantic Models (cubes), Cumulative update package 4 for SQL Server 2012 SP1 includes a bonus Power View feature – the ability to “pin” view filters and to specify some basic pinned filters via URL parameters. Check out these posts to learn more: Pinning filters in… Read more

Real World Example of Using Power View

The following blog post and video looks at how a real business used Power View to dramatically drive the business through insights and help make business decisions. The video demonstrates how Power View as well as Power Pivot and Excel was used to analyze the business data such as  sales by year, by product and sales comparisons across time periods. The… Read more

SSRS Parameters, Authentication, and SharePoint Integration — Test Your Knowledge

We now have several SQL Server Reporting Services 2012 (SSRS) quizzes that you can use to test you knowledge about configuring parameters, authentication features, and integration with SharePoint. The quizzes include links to documentation related to each question. You can access the quizzes at…. Read more

SQL Server Data Tools – Business Intelligence (SSDT BI) for SQL Server 2014 CTP1

In this pre-release version of SQL Server 2014, SSDT BI is no longer included in setup. For SQL Server 2014 CTP1 no new version of SSDT BI been released, however you can use the existing version of SSDT BI to create and deploy projects for SQL Server 2014 CTP1. The Visual Studio 2012 version of… Read more

Power View for Multidimensional Models Released!

We are excited to announce SQL Server 2012 Service Pack 1 Cumulative Update 4, released today, provides the ability for customers to create Power View reports against their existing multidimensional models (a.k.a. cubes). SQL Server 2012 Service Pack 1 Cumulative Update 4 contains a few additional enhancements to the “Power View for Multidimensional Models —… Read more

SQL Reporting – build a business using reports in the cloud

See how one company uses RDL reports, Windows Azure SQL Reporting, SQL Database, and SQL Data Sync to generate new revenue streams from existing tools and expertise. Cloud SAM is a software asset management service created by the Atea group. The service uses RDL and SQL Reporting to provide informative and actionable reports to subscribing… Read more

SQL Server Data Tools – Business Intelligence for Visual Studio 2012 released online

Today we are releasing SQL Server Data Tools – Business Intelligence for Visual Studio 2012 (SSDT BI) templates. With SSDT BI for Visual Studio 2012 you can develop and deploy SQL Server Business intelligence projects. Projects created in Visual Studio 2010 can be opened in Visual Studio 2012 and the other way around without upgrading… Read more