User manual BUSINESS OBJECTS BUSINESSQUERY 6.5 FOR WINDOWS MS EXCEL

[. . . ] BusinessQuery for Excel User's Guide BusinessQuery 6. 5 for Excel Windows 2 BusinessQuery for Excel User's Guide Copyright Copyright © 2004 Business Objects. If you find any problems with this documentation, please report them to Business Objects in writing at documentation@businessobjects. com. Trademarks Business Objects, the Business Objects logo, Crystal Reports, and Crystal Enterprise are trademarks or registered trademarks of Business Objects SA or its affiliated companies in the United States and other countries. All other names mentioned herein may be trademarks of their respective owners. Contains IBM Runtime Environment for AIX(R), Java(TM) 2 Technology Edition Runtime Modules (c) Copyright IBM Corporation 1999, 2000. [. . . ] These operations include the following: · Importing universes from the repository to your computer. · Refreshing universes to reflect any changes which the designer may have made in the DESIGNER module. For information on working with lists of values and user objects, refer to "Ways of managing and customizing universes" in the online help. In the Universes list, click the universe you want to import or refresh. Note that if the repository is holding a more recent copy of a universe you have already imported, To Be Refreshed is displayed in the Status column. Working with universes 46 BusinessQuery for Excel User's Guide 3. The universe's corresponding . unv file is copied to the Universes folder, which is found under the Business Objects 6 folder in the Application Data\Business Objects folder on your computer. NOTE The Refresh button does not refresh universes. It updates the information displayed in the Universes dialog box. Building Queries Managing Queries in the Workbook chapter 48 BusinessQuery for Excel User's Guide Overview This chapter presents topics on managing queries. · Renaming, duplicating, deleting and viewing the properties of query files. A query file stores the definition of a query and the data it returns. The QueryDirector provides information on the queries in the workbook, and lets you specify how to update them. Managing Queries in the Workbook BusinessQuery for Excel's User Guide 49 Inserting an existing query When you build a query, BusinessQuery stores its definition and the data it retrieves in a query file. When you insert an existing query, the data from its corresponding query file is placed in the worksheet. You can also request that the query be edited or refreshed before the data appears. Before inserting a query, be sure that: · You have selected an empty cell or range of cells in which data can be placed. If you select a cell containing data, the Insert Query command is dimmed. This is especially important when the worksheet contains other queries or data from other data. By controlling the way data is inserted, SmartSpace ensures the integrity of the data in the worksheet. Click a blank cell in the worksheet where you want the data to appear 2. Select the Insert Query command or click the Insert Query button on the toolbar. BusinessQuery displays the Insert Query dialog box which lists the query files currently stored in the MyBQY folder. However, you can choose another folder from the File Insert Query Inserting an existing query 50 BusinessQuery for Excel User's Guide Locations tab of the Options dialog box. In the dialog box above, there are queries called Best Customers, Revenue per Customer from 1995, and Customers and Services. They were built on a universe called Island Resorts Marketing stored in the local repository. 4. - To select a query that is not stored locally, click the Browse button, and use the browser to indicate its location. [. . . ] This means that BusinessQuery applies the same strategy each time data is inserted or removed. When you click this option, the Predefined Strategy group box becomes active. You can then select a strategy: Portrait Layout, Landscape Layout, or Custom. These strategies are described below. Always use the following strategy Selecting the strategy The Options dialog box contains three options for predefined strategies called Landscape Layout, Portrait Layout, and Custom. [. . . ]