I have created a Webi Report, published it to InfoView and then try to publish a results block as a BI Service. After having successfully done that I am grabbing the URL from Query as a Web Service tool and pasted it into a Query as a Web Service data connection in Xcelsius. After having imported the web service I see that it shows only one column of data rather than the four columns that were defined within Webi. The most interesting part is that when I map the nbColumns and nbLines, they return exactly the numbers that I would expect.
Is there something that I am missing?
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.