I am using Xcelsius 2008 SP4 and have a connection issue with my dashboard.
This dashboard is using Excel XML Mapping and worked great until I updated the XML file and some additional data was added. At first I thought it was the caching issue that is discussed on the forums, so I deleted my cookies, temp files etc…to no avail.
All the integration is showing the correct data in the xlf file when I refresh the data in the file itself, however, when I export to a swf file, the correct data is still displayed, but it is cut off at the number of lines from the previous XML file. For example the previous file shows 50 lines spread thru a scorecard component, and the new XML file has 82…nothing shows past the 50th line.
Any help with this issue is greatly appreciated. This is my first time using Excel mapping so I am kind of feeling my way thru it.
When I refresh the data on the spreadsheet in design mode, all my formulas are showing the correct data as well as the correct amount of data. The components bound to those formulas are correct as well.
It is specifically cutting off the data when I either preview or export to a swf file.
Is it possible that I have to ‘remap’ the Excel mappings to the XML File? I hope not, I am trying to make this as seamless as possible so it doesn’t have to be touched every month.
That’s a limitation of XML Maps. Neither it provides an option to manually expand the area like a live office or XML Data connection, nor it expand based on the data size.
To workaround this, you will have to build your XMLMaps while design in such a way that it returns the maximum number of records. This will ensure that the XML Maps connector mapped to a larger area which can accommodate any feed.
The better approach would be to use an XML Data connector which is much more stable and flexible. However you need a developer support to build the connector.
(BOB member since 2010-09-28)