Options Dialog in Excel Add-in

image_pdfimage_print

The tabs in the Options dialog allow you to customize some features of Jedox Excel Add-in, such as language and file locations. Note that some changes take effect only after restarting Excel.

General options tab

These options are described below the screenshot:

Jedox version check: checks for updates when Excel is opened. When unchecked, a link is displayed, allowing you to manually check for the latest version of Jedox.

Enable Excel status bar messages: Jedox occasionally displays messages in the status bar, especially when a process may take longer than usual. The option to display these messages is selected by default. Note: messages from Excel itself may be overwritten when Jedox messages appear. Disable this option if you want to see only Excel messages.

Always use rule-calculated values for copy, like, and predict operations: this option applies any existing rules to values that are splashed in cells.

Enable offline mode support: activates the menu options for working offline. Requires Excel restart.

Use Jedox Web dialogs: this option allows you to choose whether native Excel dialogs or Jedox Web dialogs are used. Note that Jedox Web dialogs require an active Jedox connection. See table below for the current availability of dialogs:

Available as Excel dialogs and Jedox Web dialogs Available only as Jedox Web dialogs
  • Paste View*
  • Subset Editor
  • Paste Elements*
  • Paste Data Function
  • Success Charts
  • Planning Assistant
  • Hold Manager

*These dialogs are not yet available in Excel as Jedox Web dialogs.

  • Modeler
  • Data-Driven Modeling
  • GPU Advisor
  • Publish to Reports (Export)
  • Edit Jedox Spreadsheet (Import)
  • SVS Editor

Enable Preview Features: this option allows you to enable or disable IN PREVIEW UI features in Jedox Excel Add-in.

Language: selects the user interface language for Jedox Excel Add-in.

Style path: specifies the path for styles that can be applied in the tab Options of the Paste View dialog.

Log path: specifies the path for recording events in Jedox Excel Add-in and Office Add-in.

SSL Certificate: specifies client certificates required for secure communication with the Jedox In-Memory DB Server (see below).

Connection-related settings: here you can activate your license and change your password.

Dialog options tab

These options are described below the screenshot:

Controls: when selected, it opens the options “More” in the Paste View, Paste Elements, and Select Elements dialogs.

Sort order of cubes: sets the default sort order for cubes in all dialog windows.

Paste View options:

  • By default, the checkmark Display gridlines is not set. The setting here will be transferred to  the Paste View dialog of Excel Add-in, and there to Layout Options in the tab Options. The selected option in this dialog will also be entered in the registry and remain there even after update installations.
  • Expand all nodes: if set, double-clicking the left mouse button expands/collapses one level of all nodes with the same name. Several identical names can be found in inner dimensions of row titles or column titles in a Jedox view. If not set, double-clicking the left mouse button expands/collapses only one level of the current node.
  • Use the element name path: preselects the “Use element name path” option under Data Options in the tab Options of the Paste View dialog.
  • Group stored views by cube:

Option unchecked:
Stored views are displayed in flat list

Option checked:
Stored views are grouped by cubes

  • Disable Select View in Ribbon: Disables the Ribbon command “Select View” to select a stored view.

Modeler options tab

These options are described below the screenshot:

Delete cache when closing Excel: when selected, deletes cached files from the web-based dialogs (commands Modeler, Publish, Edit Jedox Spreadsheet) whenever Excel is closed. By default, the option is not enabled.

Before downloading a file, always ask where to save it: if set, a user is prompted for a storage folder whenever a file is exported from Modeler (e.g. cube/dimension download, or database script). If the option is disabled, it can be defined as a default folder for all by Jedox downloaded files.

SSL Certificate dialog

You may receive notice from your IT/Jedox administrator that you must update your Jedox SSL certificate. You will need to copy and paste the certificate provided to you into Excel.

To do so, open the Options menu in the Jedox ribbon and click on the icon next to the SSL Certificate field. The SSL Certificate dialog appears:

Simply copy and paste the certificate into the field and click Save.

image_pdfimage_print