Flexible excel data range for List Box and QaaWS?
Hi, I am new to Xcelsius. I am using Xcelsius 2008 and have created the QAAWS data connection to extract SAP BI data via BO Universe.
Issue: I want to extract LOV of Shopping cart date from SAP BI. The no. of records returned is not fixed. However, using List Box and QAAWS connection, fixed cell range in Excel is required. If I have selected the bigger cell range (eg.10 cells) in Excel for QAAWS connection, but the available record returned from SAP BI is only 4, List Box will display 6 undefined value in the xcelsius.
Is there a way to defined flexible data range shown in list box and QaaWS?
Any help and advice is really appreciated. Thank you