Displaying OLAP data in a pie chart

You can display OLAP data in a pie chart by using a multidimensional query to obtain query results.

About this task

Pie charts that are run using multidimensional queries allow you to roll up data across one or more columns in the associated query result set. This allows users to drill down into specific data symbols to obtain only the data they need, without having to view the entire result set at once.

To insert a pie chart that displays OLAP data:

Procedure

  1. Double-click the Pie Chart object in the Layouts palette of the Palette view.
    The Pie Chart Wizard opens.
  2. In the All Data Sources tree, navigate to an OLAP query in the Multidimensional Data Sources folder that will be run to obtain the layout object's query result set and click Next.
    The Select dimension or hierarchy page opens.
  3. Select one or more dimensions of the cube model that you want to use to express the query results and click Next.
    Select more than one dimension by holding the Ctrl key and clicking the dimensions that you would like to use.
    The Select options for the pie chart page opens.
  4. In the Wedge values drop-down list, specify the name of the column of data in your query result set that will contain the values for each pie wedge in the pie chart.
    You must select a data column from the drop-down list of available data columns in your query result set.
  5. Select the Include a label for the wedge check box to include a label for each wedge.
  6. In the Label field drop-down list, specify the data column in your query result set that will contain the label information for each pie wedge.
    You must select a field from the drop-down list of available data columns from you query result set if you selected the Include a label for the wedge check box.
  7. Select the Include the value of the wedge check box to display in the pie chart the value of each wedge.
  8. Select the Include the percentage the value represents of the whole pie check box to display a percentage value for each pie wedge.
  9. Click Finish.
    The Pie Chart Wizard closes and the chart is displayed in the editor window.