SAP Knowledge Base Article - Public

1543437 - Leading blank spaces are removed in Xcelsius.

Symptom

Leading blank spaces in the database field values are removed in Xcelsius.

Environment

Xcelsius 2008 Service Pack 3

Reproducing the Issue

1.  Create a QAAWS query based of some database field which has leading blank spaces in the values.

2.  Notice that the QAAWS tool shows the data with the leading blank spaces.

3.  Create a sample dashboard in Xcelsius and add Query as a Web Service connection from Data Manager.

4.  Import the QAAWS query to Xcelsius and bind the connection.

5.  Insert a Spreadsheet Table component to the canvas.

6.  Bind Spreadsheet Table component to QAAWS query cells.

7.  Preview the model.

8.  See the data in the Spreadsheet Table component and notice that the leading spaces are truncated.

Cause

This issue has been identified and logged under Problem Report ID: ADAPT01369835

Resolution

This issue has been resolved in Xcelsius Service Pack 3 Fix Pack 2.

Keywords

Leading, Blank Spaces, Trimmed , KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Xcelsius Enterprise 2008