Recently I am working on a PPS solution for the SharePoint 2010. PPS 2010 introduces a new feature called Decomposition Tree that allows users to interactively drill down to the details. The Decomposition Tree option enables all of the following in one simple browser window:
- Show how an individual value in a report can be broken down into its contributing members.
- See all the members in a group in descending order
- Choose which dimension you want to use for the next level of detail.
After I deploy my new dashboard to the SharePoint site,I cannot find the Decomposition Tree menu by right clicking on the Grid or the Chart.
Doing several researches, I find that there is no Microsoft Silverlight installed on my client machine.
Microsoft Silverlight enables this option. If it is not installed, or disabled, the menu command will be hidden. In addition, if you are using an analytic chart or grid, you must design it using the Design tab, not the Query tab in order to use the Decomposition tree feature.