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. Business Objects is an SAP company. All other product and service names mentioned are the trademarks of their respective companies. [. . . ] To remove a selected member, press the red X button. Dimension* Value range You can select a start and an end member to define a range of values for this dimension. Dimension* Selection option You can select an operator and corresponding members to define a selection for this dimension. The following operators are available: Between, Outside, Equal To, Not Equal to, Greater Than, Greater Than or Equal To, Less Than, Less Than or Equal To. To remove a selection, press the red X button. Hierarchy Hierarchy node* You can select a hierarchy from the list box to define a prompt value. Single value You can select one hierarchy node as the prompt value for the selected hierarchy. 50 2010-07-13 Analyzing Data Prompt Type Value Definition Hierarchy node* Multiple value You can select multiple hierarchy nodes as the prompt values for the selected hierarchy. 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. 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. If the validation is successful, the crosstab 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. 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. If values are already saved with the workbook, these are displayed as predefined settings in the dialog. A refresh happens when you open a workbook and select refresh, when you select the setting above and open a workbook or when you insert a new data source. If this property is not selected, the system checks whether the workbook contains mandatory variables that no values are available for. [. . . ] For more information about the trace tool environment, 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 > Trace Tool Environment. Enable Profiling To activate the query runtime statistics of SAP NetWeaver BW, select the Enable Profiling check box. Using the query runtime statistics, you can find out how much time the execution of certain user actions require in Advanced Analysis and in the analytic engine of BW. The system records the performance-critical parts of the processing (statistics events). [. . . ]