User manual BUSINESS OBJECTS SAP BUSINESS OBJECTS ADVANCED ANALYSIS EDITION FOR MICROSOFT OFFICE RELEASE 1.0 SP1

[. . . ] User Guide: SAP Business Objects Advanced Analysis, edition for Microsoft Office Release 1. 0 SP1 2010-07-13 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. [. . . ] Press the Filter button if you want to select multiple values in a list at once. To remove a selected member, press the red X button. Formula You can enter a numeric value. The numeric value is used for measure calculations defined in BEx Query Designer with prompts. Text You can enter a text. This prompt type can be used to assign text to columns or row headers or to change the description of a calculated measure. * For these prompt types, you can enter the values manually or using input help. When you open input help, no values are selected. You can search for members or select members directly from the list. You can also define if the members in the list should be displayed with key, text, or both. For hierarchical dimensions, you can define if the members should be displayed in hierarchies, at leaf level, or on a specific level. Press OK to apply the selected values to your data. If the validation is successful, the crosstab is displayed according to your selection. The data in the worksheet is displayed according to your selection. You can see the selected values in the Filter area on the Information tab in the design panel. The defined prompt values can be saved with the workbook and are then available to other users or in other sessions. To change the prompt values, open the prompting dialog again. 4. 3. 2 To select workbook properties for prompting You can select various workbook properties in the design panel that affect the behavior of the prompting dialog and existing prompt values: 1. Select the required workbook properties in the Properties area. The following properties are available: · Refresh Workbook on Opening 51 2010-07-13 Analyzing Data If you select this option, the data sources in the workbook are refreshed every time the workbook is opened. The behavior of the prompting dialog depends on the other properties you selected for this workbook. If this check box is not selected, the data in the workbook is not automatically refreshed on opening. You can refresh the data sources manually with choosing Refresh All in the menu. · Force Prompt for Initial Refresh If you select this option, the prompting dialog is displayed on every refresh. The dialog appears, even if the query contains only optional prompts. If values are already saved with the workbook, these are displayed as predefined settings in the dialog. [. . . ] entry is only visible if statistics are available. For more information about the query runtime statistics, see SAP Help Portal at http://help. sap. com SAP NetWeaver > SAP NetWeaver by Key Capability > Information Integration by Key Capability > Business Intelligence > BI Platform > OLAP > Performance Optimization > BEx Monitor > BI Query Runtime Statistics. Display Technical Names To switch on the technical names of the dimensions in your Advanced Analysis workbook, select the Display Technical Names check box. The dimensions are displayed with technical name and text. 79 2010-07-13 Settings 80 2010-07-13 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. [. . . ]