Export (0) Print
Expand All

Overview of the PerformancePoint Decomposition Tree

 

Applies to: SharePoint Server 2010 Enterprise

Topic Last Modified: 2011-01-17

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.

tipTip
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:

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.

noteNote
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
  1. 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.

  2. 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.

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
  1. 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.

  2. 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.

  3. Click a decomposition node. A list of dimensions and hierarchies is displayed.

  4. 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.

  5. Repeat Steps 3 and 4 to show additional levels of detail in the view.

  6. 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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft