Global Settings
Use
With this function, you can configure default settings for the whole application, rather than for individual workbooks (see Workbook Settings).
Features
You can configure global settings for the trace file, local history, SAP GUI, and default workbook.
Behavior
Maximum Number of Objects in Local History
You use this dropdown box to configure the maximum number of objects to be displayed in your local history. Local history is a submenu that appears in the Open tool in the analysis toolbar and lists the workbooks and queries that you have open.
The submenu only displays the number of queries or workbooks that you have configured using this setting. If you have not opened many items, the system only displays those that are open.
To turn off the display of the local history submenu, you set this value to zero.
Display System Name in Local History
The Open function in the analysis toolbar displays the workbooks or queries (shortcuts) that you have opened earlier in the same session. If you want to open these again, you do not need to search for them. However, if you want to open a workbook or query from a specific system, you do not know if the available shortcut refers to the system you want to use.
This feature allows the system to display the system names alongside the workbook or query shortcuts. This allows you to check if the workbook or query that you want to access refers to the system that you want to use.
Log Onto and Activate SAP GUI Connection
When you select this function, messages such as transport messages from the server are displayed. In some situations this is necessary; for example, if you save a workbook while the standard transport system is activated.
For performance reasons, we recommend that you do not select this function.
Launch Version SAP BW 3.x of the BEx Analyzer from SAP GUI (RRMX)
This feature determines which version of the BEx Analyzer is to be opened from transaction RRMX of the SAP BI system. If you select this option, the BEx Analyzer of SAP BW 3.x is opened when you use transaction RRMX in the SAP BI system. If you do not select this option, the BEx Analyzer of SAP NetWeaver 7.0 is opened.
You can use transaction RRMX_CUST to specify for all users which version of the BEx Analyzer is started.
The following settings are possible:
● Start the BEx Analyzer depending on the version of the workbook (value: <empty>)
● Always start the SAP BW 3.x version of the BEx Analyzer (value: 3.x)
● Always start the SAP NetWeaver 7.0 version of the BEx Analyzer (value: 70)
Note that users can overwrite these central settings.
● By choosing System → User Profile → Own Data → Parameters in the menu, you can make user-specific settings for parameter ID RRMX_VERSION (values as described above).
These settings apply for a user in all systems and on all computers.
● It is possible to make a local setting for a computer using the global settings in the BEx Analyzer.
You can also make these settings in the SAP Implementation Guide under SAP NetWeaver → Business Intelligence → Settings for Reporting and Analysis → General Settings for Reporting and Analysis → Set BEx Analyzer Version.
Launch BEx Analyzer when MS Excel Starts
If you have selected this option, the BEx Analyzer starts as soon you open Microsoft Excel. If you have not selected this option, you must start the BEx Analyzer manually.
Display Messages for Troubleshooting
If you set this indicator, additional messages are displayed that could be helpful when you create your workbook.
Number of Seconds Until Popup for Termination is Displayed
Here you define how many seconds after starting an action the popup for terminating the action should be displayed.
Do not Execute Exit Macros
If you set this indicator, the macros specified on tab Exits in the workbook settings are not executed when you open the workbook. You can use this to test if problems are connected with the macros when you open the workbook.
Repair Workbook During Execution
Program errors or performance problems when opening and working in workbooks may be due to the fact that too many objects, that are no longer used, exist in the background. If you set this indicator, these objects are deleted the next time you open the workbook.
For more information, see SAP Note 1160093.
Default Workbook
You use this set of functions to view and select the default workbook. The default workbook is the workbook into which queries are opened. You can adjust a workbook (including the individual worksheets) by using the Microsoft Excel functions or the design functions in the BEx Analyzer. You can then define the workbook as the default workbook for all subsequently opened queries.
Workbooks must be stored on the server and opened from the server (rather than locally) to be set as default.
In design mode, worksheets are protected in the standard setting in order to prevent you from deleting design items unintentionally. Work in analysis mode to format your workbook.
In this dialog box, you can view and set the following properties for the default workbook:
● The Current Default Workbook field displays the name of the current default workbook.
● To set the workbook you currently have open as your default workbook and therefore override the system default, choose Use Current. You must have opened this workbook by choosing Open → Workbook to set it as the default. Local workbooks that are not saved on the server cannot be used as default workbooks.
● To set the current default workbook to the default specified in the system, choose Use Default.
● To use the SAP default workbook, choose Use SAP Standard. The SAP default workbook cannot be adjusted or modified.
● To use the selected workbook as the default workbook for all users, set the Global Default Workbook indicator. The indicator is only input-ready if the user has the necessary authorization. Authorization object S_RS_TOOLS is required. Field COMMAND must contain value THEMES.
In any one system there is a default workbook for every user. If the user does not select his or her own default workbook, the global default workbook is used.
Customizing Default Workbooks
You can format a workbook using all the Microsoft Excel functions. The following options are available, for example:
● Add a background graphic to the worksheet
● Add additional worksheets with design items or charts
● Embed a VBA macro that allows you to easily access the BEx Analyzer object model to enhance your workbook with BEx-specific custom VBA code
● Format cells outside of design items with text, borders, and colors
● Add a logo to a particular cell (outside the range of a design item)
You can also format a workbook using the BEx Analyzer design functions:
● Add or remove design items that you want to display by default
● Change the locations of design items
● Apply a BEx theme (see Workbook Settings)
Cells belonging to design items themselves use a standard formatting. Using Microsoft Excel functions, you can manually format these cells in analysis mode. For example, you can select a row of results in the analysis grid and set the text to bold. However, when you refresh the query, the standard formatting for the query cells is restored and the settings for these cells are lost.
You can permanently format design item cells in two ways:
● Using BEx themes, you can select different formatting themes, including formatting for design items. See Workbook Settings.
● With certain types of queries, you can work in formula mode, which gives you complete freedom to format the cells as required. See Working in Formula Mode.
For example, your current default workbook consists of a background graphic and the Navigation Pane and Analysis Grid design items. You work with different queries in which exceptions were defined. You want to be able to display exceptions easily when you open queries in the BEx Analyzer. You want to display a background graphic that contains an exception alert symbol. You proceed as follows:
● Create a new blank workbook using Microsoft Excel function New.
● In analysis mode in the BEx Analyzer, choose Format → Sheet → Background in the Microsoft Excel menu, and select a different background graphic.
● Use the BEx Analyzer design toolbar to insert a List of Exceptions design item. If you were not already connected to a system, you are prompted to connect now.
● Insert an Analysis Grid design item to display the query results.
● Choose Save → Save Workbook As in the analysis toolbar, and save the workbook to the server.
● Close the workbook.
● Choose Open → Open Workbook and open the workbook from the server. This is a prerequisite to be able to define workbooks as default workbooks.
● In the analysis toolbar, choose Global Settings, and in the Current Default Workbook section, choose Use Current. Your customized workbook is now the default workbook.
● Choose Open → Open Query and select a query.
Your query now opens in the workbook you have defined as the default. The Exception design item is already embedded in your workbook and your custom background graphic is displayed.
Trace
The trace file is a text file that contains a log of the BEx Analyzer activities. It is stored in your system’s temporary folder. You can view and set the following trace file properties:
● The Name of Trace File field displays the path to and name of the trace file (BexAnalyzerTrace.txt).
● Select the Record Trace checkbox to record trace information to this file.
You can delete the contents of the trace file by switching Record Trace off and then back on again. Save the contents of your trace file before you turn off Record Trace.
● Choose the Display Trace pushbutton to display the file that is using your system’s default text editor.
The trace display is not constantly updated, meaning you must choose Display Trace whenever you want to display the most recent entries.
Statistics
This setting allows you to record statistical data, for example, display of grids and time taken to execute a query. You can use this data to analyze performance issues or to get technical support if needed.
Select the Collect Statistical Information checkbox to enable this setting. The system records the statistical information. When you choose Display Statistical Information, the system displays the statistical information in a separate workbook.
Activities
Choose Global Settings in the analysis toolbar or BEx Analyzer → Global Settings in the menu.
More Information:
● Open