Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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. In a Decomposition Tree, members are ranked from greatest to least, or from least to greatest. 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.

A Decomposition Tree might resemble the following image:

Analytic view that is available in PerformancePoint Services

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?

Dashboard authors do not create the Decomposition Tree by using PerformancePoint Dashboard Designer. In addition, you do not see a Decomposition Tree as a top-level view that is always displayed in a dashboard alongside other views. Instead, you open the Decomposition Tree from a view in a dashboard that has been deployed to Microsoft SharePoint Server 2010.

Note:  In order to open and use the Decomposition Tree, you must have Microsoft Silverlight 3 installed on your computer. Also note that depending on how a scorecard or an analytic view is configured, you might not be able to open the Decomposition Tree.

To open the 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.

Top of Page

How do I use a Decomposition Tree?

You would typically use a Decomposition Tree to see how an individual 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, 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.

Using the Decomposition Tree, you can also view member properties for a particular dimension member, as shown in the following image:

PerformancePoint Services

When you use the Decomposition Tree, you 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:

  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.

Top of Page

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!