User manual BUSINESS OBJECTS ENTERPRISE XI 4.0 LIVE OFFICE USER GUIDE 2010-11-05

[. . . ] Live Office User's Guide SAP BusinessObjects Enterprise XI 4. 0 2010-11-05 Copyright © 2010 SAP AG. All rights reserved. SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP Business ByDesign, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and other countries. Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Decisions, Web Intelligence, Xcelsius, and other Business Objects products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Business Objects S. A. Business Objects is an SAP company. All other product and service names mentioned are the trademarks of their respective companies. [. . . ] The Move Result to the Left Button and the Move Result to the Right Button moves the results to the left or right in the "Result Objects" pane. The Move Filter Up Button, Move Filter Down Button, Move Filter Outside Button, and Move Filter Inside Button buttons move the filters in the "Filter Objects" pane. 5. 1. 3. 1 Understanding query object types On the Insert wizard Specify Query page, the folders and objects available in the selected universe are listed in the Manager pane to the left of the window. When you expand the folders, the objects are listed with an icon to indicate the object type. You can drag the objects to the Result or Filter panes to build your query. Objects can be one of the following types: 45 2010-11-05 Working with Queries Object type Description Dimension object A dimension object represents data that provides the basis for analysis in a report. Dimension objects typically retrieve character-type data, for example; customer names, resort names, or dates. A detail is always attached to the dimension for which it provides additional information. For example, [Age] is a detail object that is associated with the [Customer] dimension. A measure object retrieves numeric data that is the result of calculations on data in the database. For example, [Revenue] is the calculation of the number of items sold multiplied by item price. A precondition object is a predefined filter and can only be placed in the Filter Objects pane. For example, [This Year] is a predefined filter to restrict the data set to the current year. Detail object Measure object Precondition objects 5. 1. 3. 2 To add objects to queries You add objects to build queries by dragging objects from the Manager pane to the Result Objects or Filter Objects panes. Objects in the Result Objects pane form the columns of the Live Office object. For example, a query might include the Year, Sales Rep, Customer Name and Dollar Amount. Objects in the Filter Objects list restrict the results of the data set. For example, you might filter by year to show only the values for the specified year. In some databases, date-dependent attributes and hierarchies are evaluated through a key date variable (KEY DATE). For example, financial results might be posted on a specific date or at the start of new fiscal years. If the universe you selected, contains a Key Date variable, on the "Specify Query" page, the [KEYDATE] prompt and its current value are displayed on the right above the Result Objects pane. You can change the key date value in the "Keydate Properties" dialog box that opens when you click the key date button on the top right corner of the "Specify Query" page. Note: All objects except Precondition objects can be added to both the "Result Objects" and "Filter Objects" lists. Precondition objects can only be added as a filter object. 46 2010-11-05 Working with Queries After you add objects to the query, you can refine the query by setting filter types, ranking objects, and sorting the data set. [. . . ] The following Live Office functionality is unsupported for this version of Live Office. In-place drill functionality in Interactive Analysis and Crystal Reports Live Office does not support in-place drill functionality for either Interactive Analysis or Crystal Reports rowsets and report parts. In Live Office, the object refresh reflects the last saved drill state. Windows NT authentication Microsoft Corporation has replaced Windows NT authentication with Windows Active Directory. [. . . ]