SAP Knowledge Base Article - Preview

1182064 - How to create a pie chart with only two measures (or two dimensions)?


You want to create a pie chart and you only have two measure objects, but the pie chart only displays one measure.

For example, you want to produce a pie chart based on number of 'YES' and 'NO' answers that customers gave to a survey. The following Excel spreadsheet appears to have two separate measure objects:

Yes No

12 18

However, it has only one dimension, let's call it "Answer", and one measure, let's call it "Numbers for each type of Answer".

The issue is that if you create a report based on this spreadsheet, then BusinessObjects will consider it a database containing two measures. This can be verified in the microcube.

If you select "First row contains columns names" when you open the Excel file, then it will only change the appearance of the table, but it will not effect the way BusinessObjects processes the objects (i.e., two measures). Therefore, the charts created will be meaningless.



SAP BusinessObjects Business Intelligence platform 5.1.8 ; SAP BusinessObjects Business Intelligence platform 5.1.9


pie chart,pie graph, graph , 1352 , KBA , BI-BIP , Business intelligence platform , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.