The BI service does not work the same as the QaaWS. It is not as nice as QaaWS is when it comes to mapping the data from your rows and columns
Basically the BI Service contains data in the table and headers sections and you need to map the data to Excel via the cell object under each heading.
Therefore, to map a vertical table of 3 columns by 10 rows into Excel cells A1:C11 you would map the cell object under headers -> row -> cell to A1:C1 for the table headings and then map table -> row -> cell to A2:C11 for the the table values.
This will give you a table of data that is similar to the object the BI Service was created from in Webi.
If you haven't solved it already, I hope this helps.
We did already find a resolution to this and it is as you described so I will award points.
Just a quick follow-up question for you... Do you use BI Services much at your company? I have seen no reason yet to not use this as our preferred data connection type in Xcelsius.
In my experience, using this connection type is a good way to link BEx queries to Xcelsius without having to create a Universe on top of the query. You can also use a direct NetWeaver connection, but that will store the dashboard in BW instead of the BO environment.
