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. Business Objects is an SAP company. All other product and service names mentioned are the trademarks of their respective companies. [. . . ] In the following documentation the Advanced Analysis term prompt is used for these variables. All variables and values of these variables that a query contains, are displayed in the Variables area on the Information tab in the design panel. 55 2010-10-04 Analyzing Data To find more information about the definition of variables in the BEx Query Designer, go to the SAP Help Portal http://help. sap. com > SAP NetWeaver > Select release and language > SAP NetWeaver Library > SAP NetWeaver by Key Capability > Business Intelligence > BI Suite: Business Explorer > Query Design: BEx Query Designer > Reusable Query components > Variables. Related Topics · To define prompt values · To select workbook properties for prompting 5. 3. 1 To define prompt values 1. In the Prompts Summary area, you see a list of all available prompts in the query and the selected values. In the Specify Value for Prompts area, you can expand single prompts to define values. If default values for the prompts are defined in BEx Query Designer, they are displayed as selected in the prompting dialog. In the list box, select whether all prompts, no prompts or only the mandatory prompts are expanded in the Specify Value for Prompts area: · · · Select Collapse All if all prompts should be displayed collapsed. Select Show all mandatory prompts if only these prompts should be displayed expanded. Depending on the prompt definition in BEx Query Designer, you have various options: 56 2010-10-04 Analyzing Data Prompt Type Value Definition Dimension* Single value You can select one member as the prompt value for this dimension. Dimension* Multiple value You can select multiple members as the prompt values for this dimension. 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. 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. 57 2010-10-04 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. [. . . ] In the "COM Add-Ins" dialog box, make sure that Advanced Analysis option is activated. The Advanced Analysis ribbon is available again. 8. 2 To enable the Advanced Analysis Add-In after system crash (Microsoft Excel 2003) If Microsoft Excel 2003 crashes, and you have to close the application, the entries in the Advanced Analysis menu might be disabled by the Microsoft application. If this happens, you have to re-enable the Advanced Analysis Add-In in Microsoft Excel. In the Tools menu, choose Add-Ins. . . . 93 2010-10-04 Troubleshooting 3. [. . . ]