How to: |
You can create a new report query directly from Excel by accessing the WebFOCUS Quick Data Add-in. Specify connection attributes and the data source for your query, and then build your report using InfoAssist. You can place multiple queries in the same worksheet, or spread them out over multiple worksheets in a workbook.
There are limitations with queries that overlap. However, there are data layout options available in the Query properties of Excel that can assist with overlapping queries. This behavior is governed by Excel, not WebFOCUS Quick Data.
Note: Quick Data is a WebFOCUS Business User Edition option, which requires a separate license and installation. For more information about licensing Quick Data, contact your Information Builders representative.
You can also right-click any cell and select Create WebFOCUS Query.
Note: Do not end the URL with the / sign.
The next screen opens, where you can select a folder to open a list of available data sources.
InfoAssist opens, where you can build a query and run it to return the output data to Excel.
This example covers multiple aspects of creating a new report query using the WebFOCUS Quick Data tool from an Excel file.
The Web Server Connection dialog box opens.
http://localhost:26000
Note: Do not end the URL with the / sign.
InfoAssist opens.
After you perform the steps up to this point, the InfoAssist window looks similar to the following.
The report query data is transferred to the Excel file, as shown in the following image.
Named ranges are added to the entire data table. The named range for the entire data table is QDATA1.
WebFOCUS | |
Feedback |