Options Menu

image_pdfimage_print

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

General options tab

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. 

Environment:

  • Enable Excel status bar messages
  • Use defined style for locked OLAP cells
  • Always use rule-calculated values for copy, like, and predict operations
  • Language
  • Style path
  • Log path (this option affects logging of Excel and Office Add-in)
  • SSL Certificate: client certificates required for secure communication with the Jedox In-Memory DB Server
  • Connection, license activation, and password changes
Dialog options tab

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:

  • Display gridlines: preselects the “Display gridlines” option under Layout Options in the Paste View dialog.
  • 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 Layout Options in the Paste View dialog.

GPU Accelerator Advisor:

  • Timeout (seconds): time limit for the GPU Accelerator Advisor to check if the selected cube is suitable for GPU. If the check exceeds the given time, the Advisor cannot give any recommendation.
Modeler options tab

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