Overview of the PerformancePoint Decomposition Tree
Applies to: SharePoint Server 2010 Enterprise
The PerformancePoint Decomposition Tree, new in PerformancePoint Services in Microsoft SharePoint Server 2010, is an analytics tool that dashboard users can use to perform root-cause analysis. Dashboard users can view how individual members in a group contribute to the whole.
In a Decomposition Tree, members are ranked from greatest to least, or from least to greatest. The Decomposition Tree enables users to decompose, or analyze, a group to see its individual members and how they can be ranked according to a selected measure, such as by sales amounts.
Tip
The Decomposition Tree is useful for understanding why a particular value in a report or a scorecard is what it is. However, dashboard users cannot export a Decomposition Tree to Microsoft Excel or Microsoft PowerPoint like they can with some other kinds of reports, such as scorecards or analytic charts or grids. In addition, dashboard users cannot save their analysis that they did by using the Decomposition Tree.
In this article:
How do I create or open a Decomposition Tree?
How do I use a Decomposition Tree?
How do I create or open a Decomposition Tree?
As a dashboard author, you do not create the Decomposition Tree by using PerformancePoint Dashboard Designer. In addition, you cannot display a Decomposition Tree as a top-level report view that is always displayed in a dashboard alongside other reports. Instead, dashboard users open the Decomposition Tree from a report in a dashboard that is deployed to Microsoft SharePoint Server 2010.
Note
To open and use the Decomposition Tree, dashboard users must have Microsoft Silverlight 3 or Microsoft Silverlight 4 installed on their computer. Also be aware that depending on how a scorecard or an analytic view is configured, dashboard users might be unable to open the Decomposition Tree. For example, if a dashboard user right-clicks a report or scorecard value that uses a calculated member or a background item, the Decomposition Tree option might not be available.
To open the Decomposition Tree
In a PerformancePoint dashboard that is published to SharePoint Server 2010, select a report view that uses SQL Server Analysis Services data. Examples include analytic charts and grids, and some kinds of scorecards.
In the report view, right-click a value, and then select Decomposition Tree. The value can be a cell in a scorecard or a grid, or it can be an amount in a chart.
The Decomposition Tree opens in a browser window.
How do I use a Decomposition Tree?
Dashboard users would typically use a Decomposition Tree to see how a single value in a report or a scorecard can be broken down into its contributing members. The Decomposition Tree automatically sorts results and applies an inline Pareto chart to the data. Therefore, dashboard users can quickly see the highest contributors to a particular report value. Dashboard users can also see trends across individual members that contribute to an overall value.
When dashboard users begin to use the Decomposition Tree, they typically start with one bar, which is a decomposition node, located on the left side of the screen. Use the following procedure to conduct root-cause analysis.
To conduct root-cause analysis by using a Decomposition Tree
In a PerformancePoint dashboard that is published to SharePoint Server 2010, select a report view that uses SQL Server Analysis Services data. Examples include analytic charts and grids, and some kinds of scorecards.
In the report view, right-click a value, and then select Decomposition Tree. The value can be a cell in a scorecard or a grid, or it can be an amount in a chart.
The Decomposition Tree opens in a browser window.
Click a decomposition node. A list of dimensions and hierarchies is displayed.
Select the dimension and hierarchy that you want to use. The view automatically updates to display the next level of detail for the item that you selected.
Repeat Steps 3 and 4 to show additional levels of detail in the view.
To view member properties for a dimension member, browse to a single dimension member. Click its node to open a dialog box that contains additional options, and then click Show Properties.
See Also
Concepts
Overview of PerformancePoint reports and scorecards
Plan, design, and implement a PerformancePoint dashboard