Symptom
- Text are truncated in Crystal Reports.
- OLAP Grid report based off an SAP BW BEx Query doesn't display the full hierarchy name.
- In the Crystal Reports, when viewing a report based off an SAP BW BEx Query using an OLAP connection , the hierarchy node description fields only display a maximum of 20 characters.
Environment
- Crystal Reports 8.5
- Crystal Reports 9
- Crystal Reports 10
- Crystal Reports XI
- Crystal Reports XI R2
- Crystal Reports 2008
- Crystal Reports 2011
- SAP Integration Kit
Reproducing the Issue
- In SAP BEx Query Designer, create an SAP BW BEx Query that uses a hierarchy that contains long text
- In Crystal Reports, create an OLAP Cube report off the SAP BW BEx Query
- Under the menu File, select New - OLAP Cube Report
- In the OLAP Data window, connect to your SAP system and select your SAP BW BEx Query
- When viewing the OLAP Cube report, nortice the hierarchy node text is truncated
Cause
- When viewing a report based off an SAP BW Query using an OLAP connection , the hierarchy node description fields only display a maximum of 20 characters.
- It is a Crystal Reports product limitation.
Resolution
- To display longer description fields in Crystal Reports, complete the following steps:
- Load the long text into the key 'InfoObject'.
- Build the hierarchy nodes from the InfoObject (and not from the text nodes).
- Another suggestion is to use the OLAP tool: Voyager to create report off an SAP BW query
Additional Information
An alternative method is to use the Business Explorer (BEx) Analyzer, which by default displays the shortest text of the InfoObject together with the key or long description. If you wish to show the key and medium or long description for a field in Crystal Reports, then on the 'Master data/texts' tab in the Change Characteristic Details screen, clear the 'Short text exists' checkbox.
IMPORTANT: This change affects the text-table, and impacts all queries that use this InfoObject, as well as the loading structures for the texts of this InfoObject.
Keywords
SAP LONG DESCRIPTIONS HIERARCHY OVERLAP FIELD TEXT APPEARS SHOW Crystal Reports SAP BW Hierarchy Nodes Long Description , c2016209 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem