The best way to start is by building a WebI report that gives you what you are looking for. Make sure you can build a solid query that has decent performance and returns exactly the data you need.
Then you need to figure out the best way to get that data into the dashboard. There are three main methods:
You can build a QaaWS (Query as a Web Service) in BO using the SQL from your WebI report. This has the advantages of fewer moving parts, and generally superior performance (though not by a wide margin). It has the disadvantages of being very non-obvious in how to set it up and maintain it. You will want to find the documentation on the SAP site, read it two or three times, then come back and ask questions.
You can build a LiveOffice connection to the WebI report. This is generally the simplest to set up. However, it has the most moving parts, and can easily end up failing with no clear error message.
You can publish a block from a WebI report as a web service, and build a connection on that. This is the method that I personally recommend. It strikes the balance between the QaaWS and LiveOffice methods. It is by no means perfect, but it has the fewest drawbacks.
One of the pieces to the puzzle that is extremely non-obvious is that the only way to publish a block is from within WebI Rich Client. That is also the tool you use to manage the web services.
I have created three webi reports, Passing prompts from Xcelsius to webi reports to get the data in spreadsheet.
However, it looks i am having trouble in binding the cell for prompts in xcelsius through Live office Connections.
Getting error “Failed to fetch data provider data. (LO 26306)”.
Trying to resolve it.
(BOB member since 2012-09-25)
(BOB member since 2005-01-06)