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. in the United States and in other countries. [. . . ] 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. In Live Office, the Key Date is treated as a prompt setting. 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. When you are finished defining the query, click Next. Related Topics · Ranking query objects · To sort query objects · To filter query objects · Configuring query options 5. 1. 3. 3 Ranking query objects Ranking is a method of restricting the data returned by a query. When you insert queries, you can add ranking to dimensions or objects that are based on defined measures. For example, you could set a ranking to limit the Customer Name dimension to the top seven results based on the Sum of Last Year Sales. Note: Not all universe objects support ranking. [. . . ] OLAP Intelligence functionality Live Office does not support OLAP Intelligence functionality and any OLAP Live Office objects from previous releases are not recognized. Live Office objects based on Business Views Live Office does not support inserting and modifying Live Office objects that are based on Business Views. As a workaround, advanced users can still insert from a Crystal report that is based on a Business View. 89 2010-11-05 Reference Creating Crystal reports from Excel ranges To create a Crystal report based on an Excel range, use the Crystal Reports Designer, which provides more comprehensive reporting functionality. Inserting rowsets from Interactive Analysis data providers To insert rowsets from Interactive Analysis reports, use the Interactive Analysis report part support to insert a table from an existing Interactive Analysis report. 90 2010-11-05 More Information More Information Information Resource Location SAP BusinessObjects product information http://www. sap. com Navigate to http://help. sap. com/businessobjects and on the "SAP BusinessObjects Overview" side panel click All Products. [. . . ]