A treemap that shows the relationship between two measures, represented by size and color, and their variance across a dimension. To create a treemap visualization, start by connecting to a source.
The query source can be:
Model-Based: A Multi-Dimensional Expression (MDX) query from a multidimensional data source.
Relational: A relational query, usually SQL, but could be DAX for tabular cubes.
Excel range: Data stored in the workbook. You must have at least three columns. The last 2 columns represent the segment's Size and Color.
Create a treemap using a Model-Based source
To create a treemap using cube data:
Go to Anaplan XL > Connections > Connections.
Select an existing model-based connection or add a new connection, and then select OK.
Go to Anaplan XL> Visualise > Treemap.
In the Select Data Source dialog, select Model-Based and OK.
In the Design Treemap pop-up window, drag a dimension hierarchy from the Available Hierarchies section to the Plot section, such as Product Category.
Drag and drop the member, such as All, to the Selection pane and use the dropdown select more options such as to show the Descendants of the member.
For the Values section, select or type the name a measure for the Size and Colour, such as Internet Sales for Size and Internet Order Quantity for Colour.
To modify the formatting of the values:
Select the ellipsis icons next to Size and Colour and choose your options.
Check the Apply Cube formatting checkbox to determine the format of the values defined in the source.
Use the AnaplanXLFormats sheet to determine the formatting for the treemap.
In the Split Plot By section, select Descendants At and choose a hierarchical level for the Plot dimension, such as Subcategory.
Select the Text tab and enter text before or after the placeholders, %name%, %size%, and %color% to provide more information in the treemap.
Enter text before or after the placeholders, %name%, %size%, and %color% to provide more information when a user hovers over the item.
Based on the data source selected, the MDX tab may be available. This allows you to analyze the MDX statement used in the treemap.
Select OK.
Create a treemap using an Excel Range
Relational and Excel Range data sources work almost the same way. In both, you select multiple columns. Anaplan XL treats the last two columns as size and color values and uses the remaining columns as member values. However, with a Relational data source, you can include several member columns.
To create a treemap using an Excel range as the data source:
Create an Excel file with a flat column hierarchy.
Note: Your data must have at least three columns, including data for Size and Colour.
Select the cell where you want the treemap to start. You can move and resize the treemap at any time.
Go to the Anaplan XL menu, in the Insert section, select the Visualise dropdown, then select Treemap.
In the Select Data Source dialog, select Excel Range and OK.
In the Treemap Range, type the data range in the Excel file, such as =$A$1:$E$13, or use the Pick range icon to select the range.
Select the Show second level checkbox to display child segments nested under their parent categories at the top level.
Verify the columns are correctly mapped. Select the Category checkbox for every column displaying text.
Select the aggregation method, Sum, Average, Maximum, or Minimum, for each figure column. For example, if your color metric is a percentage or ratio, change the Aggregate from Sum to Average.
Select the Formatellipsis to format the cells, choose a format, and select OK.
Format the treemap
Select the Appearance tab and select the Segments dropdownor the ellipsis to modify the gradient color.
Type a name for the treemap. Naming your treemaps helps with formatting when your workbook contains more than one treemap—you can use the name to format the treemap in the AnaplanXLFormats sheet.
For the Layout, select the dropdown and choose:
Order by size: Larger areas come first.
Natural order: Keeps the areas in their starting order. This matches the order found in tables and ranges, or cube order when the data source is a cube.
Squares: Makes the areas as square as possible, so you can compare sizes more easily.
Choose the title position when showing two levels in a treemap. For the Parent name position, select either Title Outside or Title Inside from the dropdown.
Select the Output range checkbox and use the Pick range icon to select a range to let you drive another section of the report from the treemap. If you have nested areas, you can select a range of several cells to contain the names at each level.
Select the Link to checkbox and use the Pick range icon, which is used with the Output range to jump to the section of the report updated when the treemap was selected.
Select the Activate XL3 link checkbox and use the Pick range icon if you added a XL3Link formula to your worksheet.
Select the Show back/forward checkbox to enable navigation within the treemap.
Select the Show clear selection checkbox.
Choose OK.
Interact with and navigate the treemap
Once you insert the treemap, explore and interact with your data:
View values: Hover your cursor over any tile to display a tooltip with the member name, exact size value, and color metric.
Drill down: Double-click any outer parent tile to drill into that category and inspect its child items in greater detail.
Navigate levels: Select the Back arrow in the top navigation bar to return to the higher-level parent view. Click the Forward arrow to return to a drilled level.
Filter linked reports: Select any tile to output its member label into your specified Output range cell. Connected Excel formulas (such as VLOOKUP or XL3Link)
Right-click menu: Within the treemap, right-click to be able to Drill, Edit, Refresh, Move/Size, Copy, or Delete the treemap.