Bookshelf Home | Contents | Index | PDF |
Siebel Analytics User Guide > Basics of Working with Requests in Siebel Answers > Integrating a Siebel Analytics Request with Microsoft Excel's Internet Query FeatureIntegrating a Siebel Answers data request with Excel's Internet Query (IQY) feature allows you to run the request from within Excel. This feature can be useful for printing and distributing reports. When the IQY file is opened in Excel, you are prompted to enter your Siebel Analytics user ID and password. (You must have a nonblank password.) Then, the results of the saved request are retrieved and placed in an Excel spreadsheet. You can save the Excel spreadsheet so that the data can be refreshed directly from within Excel. By default, Excel prompts you to enter your user ID and password each time the query is refreshed. Alternatively, you can save your user ID and password within the spreadsheet. Consult your Excel documentation for details. NOTE: You can integrate requests into Excel's IQY feature only with results that appear in one or more table or pivot table views. Other view types are not supported. To integrate a Siebel Analytics request with Excel's IQY feature
|
Siebel Analytics User Guide |