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.
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.
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)
Click on Visualization and now Pie is an option
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.