User manual BUSINESS OBJECTS ADVANCED ANALYSIS 1.0 SP4 EDITION FOR MICROSOFT OFFICE

[. . . ] User Guide: SAP Business Objects Advanced Analysis, edition for Microsoft Office Release 1. 0 SP4 2010-10-04 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. [. . . ] Select the required workbook properties in the Properties area. The following properties are available: · Refresh Workbook on Opening 58 2010-10-04 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. 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. If no values are available, the prompting dialog is displayed; if values are available, the workbook is displayed straight away. · Store Prompts with Workbook This is the default property. If it is used, the defined prompt values are saved with the workbook and will be applied to the data when the workbook is refreshed during the current session or closed and opened again. The prompt values are also available to other users using the workbook. To change the values, you can open the prompting dialog manually. If this property is not selected, the defined values will not be saved with the workbook. The behavior of the prompting dialog and saved prompt values will work according to your workbook properties selection. 5. 4 Filtering data In Advanced Analysis, you can define criteria to restrict the data displayed in your analysis to a subset of data. With filtering, you define which subset of data appears in the analysis. This allows you to create new, more specific views of your data. Filters are additive, which means that each additional filter is based on the current filter and further reduces the subset of data. With "Filtering members", you can specify which members to display and which not to display in your analysis. You can also define members to use as filters in the background of the anlysis. [. . . ] In the "Add-Ins" dialog box, select the options Analysis ToolPak and Analysis ToolPak - VBA. Close Microsoft Excel and open Advanced Analysis for Microsoft Excel again. The entries in the Advanced Analysis menu are available again. 8. 3 Solving issues regarding the creation of Microsoft PowerPoint slides If users encounter problems when executing the function Create Slide in Advanced Analysis for Microsoft Excel, we recommend that you do the following: Make sure that users start Advanced Analysis for Microsoft PowerPoint manually before they execute the function Create Slide in Advanced Analysis for Microsoft Excel. Users can start Advanced Analysis for Microsoft PowerPoint in the Windows directory under Start > Programs > SAP Business Objects > Advanced Analysis for Microsoft PowerPoint or by double-clicking the corresponding desktop icon. 94 2010-10-04 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. [. . . ]