SAP BusinessObjects Analysis , edition for Microsoft Office v1.0

1. SAP BusinessObjects Analysis, edition for Microsoft Office v1.0 Workbook and User Settings

2. Settings: Lesson Objectives • After completing this lesson, you will be able to: • Describe Workbook Settings • Describe User Settings

3. Workbook Settings User Settings Agenda

4. Workbook Settings • To edit workbook settings, • Choose the Components tab of the Design Panel • Choose Workbook from the drop-down box • Edit workbook properties

5. Workbook Settings • Refresh Workbook on Open • Refreshes all data sources in a workbook automatically, when the workbook is opened in Excel. • Pre-requisite: Analysis AddIn is activated. • Force Prompt on Initial Refresh • Brings up the prompt dialog on first refresh after opening the workbook, even if no mandatory prompts exist, or all prompts already have values • As Analysis Office supports only BW in its first release, prompts can be equated with BW variables in the first release • Store Prompts with Workbook • Prompt values are stored with the workbook. If the Force Prompt on Initial Refresh checkbox is not selected, users will not be prompted when refreshing the workbook, and stored prompt values will be used for selecting data.

6. Workbook Settings User Settings Agenda

7. User Settings • To edit your personal user settings, • Press the Settings button in the ribbon • Change the options in the User Settings dialog to your personal preferences • User Settings reflect your personal preferences • Support Settings are useful in situations where you need product support • They can be changed for your user, mostly upon request of your administrator, or a support person

8. User Settings (2) • Recent List • Define how many data sources are displayed in the History, or clear the History • (Simple Mode for Data Layout – will be removed) • Number Of Members Displayed in Filter Dialog • Maximum number of members displayed in the Filter by Member dialog and the Filter Component dialog • If limit is exceeded, an explanatory message is displayed at the bottom of the dialog

9. User Settings (3) • Support Settings • Are available on a separate tab page of the User Settings dialog; they help administrators or support staff analyze issues with the application • Enable BW Server Tracing (may be dropped) • Switches BW server tracing (rstt) on • Enable Profiling (may be dropped) • Enables front-end profiling • Display Technical Names • Displays technical names of BW characteristics and hierarchies in Analysis Tab

10. User Settings (4) • Logfile • The Analysis AddIn for Excel writes user messages and internal processing information into a log file • The name of the log file is SAPAdvancedAnalysisXLS.log, and it is located in the specified folder • Information is appended to the log file up to a certain maximum file size (currently 2KB). When the maximum file size is exceeded, the log file is automatically copied into a file named SAPAdvancedAnalysisXLS_<timestamp>.log, and the actual log file is cleared. • The log file is NOT cleared when a new user session starts. • Log Level - Defines the level of information that is logged in the log file: • System Exceptions (from client or server, also displayed as user messages) • Error Messages (from client or server, also displayed as user messages) • Warning Messages (from client or server, also displayed as user messages) • Info Messages (from client or server, also displayed as user messages) • Debug Information: Developer Debug Information (from client, invisible to users) • Each level logs information from all lower levels; for example. level 5 (debug information) logs all kinds of exceptions, user messages, and code debug information

11. Settings: Lesson Summary • After completing this lesson, you are now able to: • Describe Workbook Settings • Describe User Settings