Symptom
Web Intelligence and Crystal Reports for Enterprise have a limitation involving BEx Queries where a measure is the result of a calculation and is mixing data types.
These BI reporting clients DO NOT support the concept of cell-based data types.
A simple example is:
Revenue | ||
Row 1 | USA | 5 |
Row 2 | Europe | 10 |
Row 3 | % USA (of total) | 33% |
Row 4 | % Europe (of total) | 66% |
The limitation in these reporting clients is that the product is un-able to assign an unique data type and therefore the measure is assigned “String” as the data type.
In the above example the measure Revenue is not “unique” in its data type because there are numbers and there are percentages. This is just a basic example to illustrate the support problem.
This is commonly seen in situations where BEx Queries have BW Structures with Cell Editor calculations defined (i.e. financial reporting scenarios).
Read more...
Environment
- SAP BusinessObjects Business Intelligence Platform 4.0 SP04 and higher
- SAP Crystal Reports for Enterprise 4.0 SP04
- SAP Web Intelligence 4.0 SP04
- SAP Dashboards 4.0 SP04
Product
Keywords
- ADAPT01652104
- text
- webi
- ADAPT01713667
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.