Monday 08 April 2019

Create a Pie Chart in Planning Analytics Workspace

Recently, we have had customers ask why they don’t always see the option to create a Pie visualization. I am hoping to address this issue, in a short blog.

Although it should be straightforward, defining a view that allows users to display a Pie Chart does have to be configured with care.

If the view’s configuration is incorrect, the Pie Chart visualization simply will not appear as an option.

When a measures dimension is defined for a Cube

For each cube (and all associated views), a measures dimension can be assigned.

The MEASURES_DIMENSION is stored in a Control Cube and can be assigned in either Planning Analytics Workspace and/or Architect.


blog 1

In Planning Analytics Workspace, to define a Measure Dimension for a cube, follow this link, a user must have admin rights to carry out this task.

In Architect, to define the Measures Dimension, right click on a Cube and select Properties, then select the dimension to use.


blog 2

Once the Measures Dimension is defined, create a view with a measure displaying a single member in either rows or columns. Do not nest dimensions, otherwise the desired result will not be possible.

In this example:

  •  Sales (single member on the Rows)
  •  Month (dimension on the columns)

blog 3

Click on Visualization   blog 4  and now Pie is an option


blog 5

blog 6

When a measures dimension is NOT defined

When using a view of a cube that has no defined measures dimension, the only way to display a pie chart is to configure a view with a single dimension on the row position or a single dimension on the column position. A view configured this way can’t display data in an Exploration (crosstab style), but this configuration does enable the Pie option on the Change Visualization menu.


blog 7


blog 8