Symptom
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.
Read more...
Product
Keywords
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.