The Global page enables you to set options that affect all worksheets and actions in your Essbase session.
Limit to Connected Sheets—Select to enable compatibility between Spreadsheet Add-in and Oracle Hyperion Smart View for Office, Fusion Edition.
When selected, Spreadsheet Add-in reacts to mouse clicks only in worksheets that are connected to an Essbase application and database.
Enable Secondary Button—Select to use the secondary mouse button for pivot and zoom operations.
Enable Double-Clicking —Select to retrieve and zoom in on data by double-clicking the primary button, and zoom out by double-clicking the secondary button.
Enable Linked Object Browsing—Select to access the Linked Objects Browser dialog box when you double-click a cell containing a linked object.
Information—Select to display information for every Essbase action, including all warning and error messages.
Warnings—Select to display only warning and error messages. Warning messages contain critical information that may affect your session. This is the default setting and the recommended minimal message level setting.
Errors—Select to display an error message whenever an action does not successfully complete.
None—Select to specify that messages (information, warning, or error) do not display.
Display Unknown Members—Select to display names in a retrieval request that do not match member names of the database. This option is enabled by default.
Display Save Dialog—Select to save a member selection when you exit the Essbase Member Selection dialog box.
Route Messages to Log File—Select to send a copy of all messages to the log file. When this option is selected, all messages are sent to /ESSBASE/MESSAGES.LOG on your computer. By default, Essbase sends messages to the screen only. This option does not affect other settings in the Display Messages group.
Purge Log File Every Session—Select to delete the log file each time you start an Essbase session. This option is enabled by default. Regular purging of the log file prevents it from growing too large.
Navigate without Data—Select to perform spreadsheet operations such as Zoom In, Zoom Out, Pivot, Keep Only, Remove Only, and Retrieve without returning data. This option is useful in terms of performance when dealing with Dynamic Calc members. This option enables you to get to the desired view of the worksheet without waiting for data retrieval until you need it. Clear Navigate Without Data when you are ready to retrieve data.
Add-Ins—Click to open the Add-In Manager dialog box which enables you to install and configure custom add-ins developed with the Essbase API. For information on developing custom add-ins, contact Oracle Corporation.