Using the Decomposition Tree

A Decomposition Tree is a PerformancePoint analytics tool that you can use to perform root-cause analysis by viewing how individual members in a group contribute to the whole. The Decomposition Tree enables users to decompose, or break down, a group to see its individual members and how they can be ranked according to a selected measure, such as by sales amounts. Decomposition Trees are only available on views that use SQL Server Analysis Services data.

The Decomposition Tree automatically sorts results and applies and inline Pareto chart to the data, so you can quickly see the highest contributors to a particular report value. You can also see trends across individual members that contribute to an overall value.

Note:  You must have Microsoft Silverlight 3 installed on your computer to use the Decomposition Tree. Depending on how a scorecard or an analytic view is configured, you might not be able to open the Decomposition Tree.

How do I open and use a Decomposition Tree?

To use a Decomposition Tree, use the following procedure:

  1. In the dashboard, select a view that uses SQL Server Analysis Services data. Examples include analytic charts and grids, and some kinds of scorecards.

  2. Right-click on a value in the view, 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.

Use the following procedure to conduct root-cause analysis:

  1. Click a decomposition node. A list of dimensions and hierarchies displays.

  2. Select the dimension and hierarchy that you want to use. The view automatically refreshes to display the next level of detail for the item that you selected.

  3. Repeat Steps 1 and 2 to continue drilling to detail in the view.

  4. To view member properties for a dimension member, browse to an individual dimension member. Click its node to open a dialog box that contains additional options. Click Show Properties.

The following image shows a Decomposition Tree showing sales unit costs across product categories, product subcategories, and individual products.

Using the Decomposition Tree, you can also view member properties for a particular dimension member

PerformancePoint Services

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!