PerformancePoint Services can lookup to many data sources incliding SSAS cubes, and one great feature you get when you integrate it with cubes is Decomposition Tree.

Decomposition Tree allows you to explore your cube in a visually intuitive way where you can drill down and explore key business data using various dimensions and measures defined in your cube. Once properly setup, the power then is at the finger tips of the users who can explore the data in whichever way they want, and everything is at their finger tips. This really helps business as all information is availalbe at their fingertips, and they don't need to request for specific reports to be written to see ciritical information.

SQL Server Reporting Services (SSRS) deployed in SharePoint integrated mode can host reports in sharepoint and you can pass parameters into reports using any filter webparts. This can be useful if you want to show various charts from SSAS Cubes, report from SSRS and at the same time have filter criteria which drives charts and Reports.

The screenshots that you see below are taken from my development environment with following configurations:

-> SharePoint 2013 SP1

-> SQL Server 2010 SP1

-> SSRS 2012 in SharePoint Integrated Mode

-> Adventure Works Sample database with SSAS Cubes imported to sql database (https://prolifixservices-public.sharepoint.com/Blog/Post/103/Importing-Adventure-Works-DW-Sample-database-into-your-SQL-database)

Dashboard page containing Analytic graphs that lookups to SSAS Cube, SSRS Report (SharePoint integrated mode), and a filter webpart which is connection to the graphs and report.

The Product category filter is connected to the graphs and SSRS report. When Product category is changed, the graphs and report filter its content to show sales information for the new Product category selected.

After the page refreshes, you'll now see sales information for Bikes

 

Decomosition Tree: You can use Decomposition Tree feature from any of the analytic chart. This gives users really good intuitive way to explore the data and find out crucial information with few clicks.

The tree below shows distribution of sales of Bikes into various states, then by Model of Bikes, and gender of customer and finally their martial status. The classification is based on the dimensions defined in SSAS cube. So whatever is defined in cube, you should be able to use it in decomposition tree.

There's lot more to it in the decomposition tree, graphs, reports created in performance point and various menus and options worth mentioning. But I'll just conclude this post at this point. I might cover rest in later posts.

Leave a Reply

Your email address will not be published. Required fields are marked *