Advanced Options

Advanced options are global options, which apply to the entire current workbook, including any new worksheets added to the current workbook, and to any workbooks and worksheets that are created henceforth. Changes to global option settings become the default for all existing and new Microsoft Office documents.

It is not necessary to use Apply to All Worksheets or Save as Default Options with these options.

Note:

Not all data providers support all the options listed in the table.

To set options for the administrative and other advanced tasks as described in Table 15, click Options on the Smart View ribbon, and then select Advanced in the left panel. When you are finished, click OK.

Table 15. Advanced Options

Option	Description
General	General
Shared Connections URL	Specify a default URL for all connections. Use the following syntax: http://<server>:19000/workspace/SmartViewProviders Note: This field must contain an EPM Workspace URL for Smart View online help to be available.
Number of Undo Actions	The number of Undo and Redo actions permitted on an operation (0 through 100). See Using Undo and Redo.
Number of Most Recently Used Items	The number, 15 or fewer, of your most recently used connections to be displayed on Smart View Home and the Open menu on the Smart View ribbon.
Delete All MRU Items	Delete all items in your most recently used list, including those that are pinned to the list.
Logging	Logging
Log Message Display	All error, warnings, and informational messages from the connected data source are displayed when they occur, but you can choose which of these message levels to record in a log file. Select a message level to display and record: Information: All messages, including warnings and errors — recommended to diagnose problems. May adversely impact performance. Warnings: Warnings and error level messages. May adversely impact performance. Errors: Error messages only — recommended for general use. Has minimal impact on performance. None: Suppress all messages. Extended Info: Information-level messages plus all server responses and requests. Adversely impacts performance.
Route message to files	Save log messages in a file. Click the ellipsis button to change the location of the log file.
Clear Log File on Next Launch	Clear the log file starting with the next log message generation, which will be seen after Excel is closed.
Enable Profiling (do this only by support engineer recommendation)	Provides extended Info log entries and most function calls. Creates XML files for each Office application with active Smart View. Intended for debugging. Severely impacts performance. The location of the profile file is: %APPDATA%\Oracle\SmartView\Profile For example: C:\Users\username.domain\AppData\Roaming\Oracle\SmartView\Profile
Display	Display
Language	Select a language in which to display Smart View. You must restart the Office application when you change languages. Default is the language specified when Smart View was installed.
Display Smart View Short Cut Menus Only	Display only Smart View menu items on shortcut menus. Otherwise, shortcut menus display both Excel and Smart View items.
Disable Smart View in Outlook	Disable Smart View in Outlook if you do not want to use Smart View task lists in Outlook.
Enable Ribbon Context Changing	Display the active data provider ribbon automatically after you use a button on the Smart View ribbon.
Disable options that are not valid for the active connection	Disable options in the Options dialog box that are not valid for the active connection.
Display Drill-Through Report ToolTips	Display by default lists of available drill-through reports for cells whenever you mouse over them.
Show Progress Information After (seconds)	Specify the time, in seconds, after which the Smart View Progress status bar appears when an operation begins.
Compatibility	Compatibility
Reduce Excel File Size	Compress the metadata maintained in Excel files containing Smart View workbooks. Note: This option pertains to interoperability between different versions of Smart View. If all users in your organization are on Smart View 9.3.1.6 or higher, then this option should always be selected. Clear this option in the following situations: You send an Excel workbook to users on Smart View releases earlier than 9.3.1.6, or to users on Microsoft Office 2002 and earlier regardless of Smart View release. In these workbooks: Grids that contain functions must be refreshed before data can be displayed. In ad hoc mode, POV settings are lost; the behavior is similar to that of a fresh ad hoc grid. You open a workbook sent from users on Smart View release earlier than 9.3.1.6, or on Microsoft Office 2002 and earlier regardless of Smart View release
Improve Metadata storage	Allow for more efficient storage of internal data structures. When this option is cleared, Smart View maintains two copies of metadata for compatibility purpose, which may result in slower overall performance. Note: This option pertains to interoperability between different versions of Smart View. If all users in your organization are on Smart View 9.3.1.6 or higher, then this option should always be selected. Clear this option in the following situations: You send an Excel workbook to users on Smart View releases earlier than 9.3.1.6, or to users on Microsoft Office 2002 and earlier, regardless of Smart View release You open a workbook sent from users on Smart View releases earlier than 9.3.1.6, or from users on Microsoft Office 2002 and earlier, regardless of Smart View release
Refresh Selected Functions and their dependents	Execute dependent functions on the same sheet before executing the selected functions.
Mode	Mode
Use Double click for Operations	Double-clicking retrieves the default grid in a blank worksheet and thereafter zooms in or out on the cell contents. If not selected, double-clicking retains standard Excel functionality and puts a cell into edit mode. If Oracle Essbase Spreadsheet Add-in and Smart View are installed on the same computer and you have not completed the steps in Smart View and Spreadsheet Add-in, double-clicking prompts you to log into Spreadsheet Add-in.