Decomposition Tree in SharePoint 2013 Using PerformancePoint

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 depending on a selected measure, such as by sales amounts.

Dashboard individuals would usually use a Decomposition Tree to see how a single value in a report or a scorecard can be crashed into its contributing members. The Decomposition Tree immediately sorts results and uses an inline Pareto graph to the data. Therefore, dashboard users can quickly see the greatest contributors to a specific report value. Dashboard individuals can likewise see trends across individual members that add to a total value. When dashboard users begin to use the Decomposition Tree, they normally start with one bar, that is a decomposition node, found on the left side of the display.

Learn about the Decomposition Tree

What Are PerformancePoint Decomposition Trees In SharePoint 2013

How to create a Decomposition Tree

To create a Decomposition Tree, first of all we need to create a simple analytics chart using PerformancePoint.

To create an Analytics Chart Report please refer to my previous article:

Analytics Reports Using PerformancePoint Services in SharePoint 2013

After these steps. Now it’s showing as in the following

Right-click on the chart region then select "Decomposition Tree".

Now the other window will open. This picture shows “United States” because I clicked in the region of the United States.

And again I right-clicked in Florida and it's showing the Dimensions from the cube.

Using the Decomposition Tree, you can also view member properties for a specific dimension member. Based on these dimensions we can generate the Decomposition tree.


In this article we explored how to create a Decomposition tree in SharePoint 2013.