1392796 - Excel XML Map cannot bind data to a data range of spreadsheet table which contains blank cells at the end of range in Crystal Xcelsius 2008

SAP Knowledge Base Article - Public

1392796 - Excel XML Map cannot bind data to a data range of spreadsheet table which contains blank cells at the end of range in Crystal Xcelsius 2008

Symptom

New data does not get added into blank cells of the Spreadsheet table.

Environment

  • Crystal Xcelsius 2008

Reproducing the Issue

1.  Create an XML file which has the following contents.

    <?xml version="1.0" encoding="UTF-8" ?> 
    <root>
    <row>
    <col1>1.test1</col1>
    <col1>2.test2</col1>
    <col1>3.test3</col1>
    </row>
    </root>

2.  Launch Microsoft Excel 2007. Click Data.
3.  Click From Other Sources > From XML Data Import.
4.  Select above XML file. Click Open. The Microsoft Office Excel dialog appears. Click OK.
5.  Click OK in the Import Data dialog.
6.  Click Save As > Excel 97-2003 Workbook.
7.  Type the file name. Click Save.
8.  Launch Xcelsius 2008.
9.  Click Data > Import. Click OK in the Xcelisus dialog. Select the file used in step 7. Click Open.
10. Click Data > Connections.
11. Click Add > Excel XML Maps. Click Usage tab.
12. Check Refresh On Load. Click Close.
13. Select a Spreadsheet table. Insert it into canvas.
14. Select a range ($A$1:$A$10) of Display Data in the Speradsheet table.
15. Change the XML file to add new data (2 rows) as below.

    <?xml version="1.0" encoding="UTF-8" ?> 
    <root>
    <row>
    <col1>1.test1</col1>
    <col1>2.test2</col1>
    <col1>3.test3</col1>
    <col1>4.test4</col1>
    <col1>5.test5</col1>
    </row>
    </root>

16. Click Preview

The spreadsheet table does not get the added new data.

Cause

The behaviour is by design in Xcelsius.

The issue has been identified and logged under Problem Report ID ADAPT01130108.

Resolution

Workaround: At step 1 of Reproducing the Issue, create the XML file that contains blank data from the beginning.

<?xml version="1.0" encoding="UTF-8" ?> 
<root>
<row>
<col1>1.test1</col1>
<col1>2.test2</col1>
<col1>3.test3</col1>
<col1></col1>
<col1></col1>
</row>
</root>

Keywords

xml, xls, refresh data, data manager, row, root, ADAPT, 01130108, 001130108 , KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Xcelsius Enterprise 2008