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.

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