Jedox Ribbon in Jedox Excel Add-in


After a successful Jedox installation and a restart of Excel you will see in Excel 2010/2013/2016 the Jedox Ribbon:

Jedox Ribbon items:

  • View:
     Opens the dialog “Paste View”, which assists in generating a Jedox database view with just a few mouse clicks.
  • Paste Elements:
     Instead of the Paste View function, you can insert individual elements into your worksheet.
  • Paste Subset:
    This assistant supports you in generating and inserting subsets.
  • Paste Data Function:
    Use this function to insert proper formulas for data retrieval from a Jedox database.
  • Save as Snapshot:
    When storing, all functions are replaced by their current values.
  • Save as OLAP Snapshot:
    When storing, only the Palo functions are replaced by their current values; all other functions and values are stored as normal.
  • SUCCESS Charts:
    Use this button to create SUCCESS charts.
  • Modeler:
    Use the Modeler to structure the data and to create cubes, dimensions, elements, consolidated elements, and attributes.
  • Data-Driven Modeling:
    Generate and fill a new Jedox OLAP cube from your existing data (CSV or Excel file).
  • Import Wizard:
    Use this function to import data from text files, OBDC databases, or other cubes.
  • GPU Accelerator Advisor:
    This advisor will test whether the selected cube is suitable for GPU.
  • Undo Options:
    Here you can select a range of a Jedox view for which you can take back changes gradually or as a whole.
  • Plannung Assistant:
    This assistant provides many options for entering data when consolidated elements are involved. It is especially useful for creating planning scenarios and entering data distribution along pre-defined ratios.
  • Create Hold:
    This command locks/unlocks cells with PALO.DATA functions in the current view. Each Jedox view change unlocks all cells with PALO.DATA functions.
  • Section Jedox Web:
    Under this point it is possible to load files from Jedox Web or publish files in Jedox Web.
  • Jedox Wizard:
    This wizard lets you create, edit, or unregister a connection to Jedox OLAP, Jedox Web, or Jedox Cloud.
  • About Jedox
    With “About Jedox” you get information about the software, a link to a sample application, as well as other links to related Jedox websites.
  • With the button Options” you get the following dialog box with three tabs:
    Most of the options are self-explanatory. Note that changes to “Language” and “Controls” take effect only after restarting Excel. Other changes take effect immediately.  

Tab “General options”

  • Check for updates
  • 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)
  • Connection, license activation, and password changes

Tab “Dialog options”

  • Always show all controls: activation will open the options “More” in the  dialogs “Paste View”, “Paste Elements” and “Select Elements”.
  • Sort order of cubes
  • Display gridlines:
    This option is the preselection for the checkbox with the same name in tab “Option” in the Paste View dialog.
  • Expand all nodes:
    If set, double-clicking the left mouse button expands/collapses one level of all nodes with 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 current node.
  • Use element name path:
    This option is the preselection for the checkbox with the same name in tab “Option” in the Paste View dialog.
  • Timeout (seconds): Time which the GPU Accelerator Advisor can use for his check if the selected cube is suitable for GPU. If the check exceeds the given time, the advisor cannot give any recommendation.

Tab “Modeler options”

  • Delete cache when closing Excel:
    Enforce the deletion of 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 option is disabled, it can be defined a default folder for all by Jedox downloaded files.

After installing Jedox, you will find some additional items in the Excel context menu. This menu comes up when you right-click on an Excel cell:

Below are brief explanations of each context menu item:   

  • Expand/Collapse All:
    This right mouse button command expands/collapses one level of all nodes with same name. Several indentical names you can find in inner dimensions of row titles or column titles in a Jedox view.   
  • Drill Through:
    This command displays the detailed data for OLAP cells in the case that the Jedox OLAP cube contains drillthrough data.   
  • Drill History:
    Displays the history of changes on OLAP cube cells. The history will be recorded after the storage of audit information is enabled for the whole OLAP Server generally and additionally for the concerned cube.   
  • Cross Drill Down:
    With Cross Drill Down you can exchange column titles or row titles with other displayed titles in the current view with one click.
    When the target element of a Cross Drilldown exchange is a base element, its parent elements and its direct siblings will also be shown as row/column titles.
    If you press simultaneously “Ctrl” you will get the new view in a new workbook.
    If you press simultaneously “Ctrl” + “Shift” you will get the new view in a new workbook and all opened workbooks arranged side by side on the screen.   
  • Trace Cell Value:
    Returns various information about the linked Jedox cube cell.   
  • Paste Values in Cube View:
    This item is to paste copied values into the cells of a Jedox cube view.  
  • Create Hold:
    Defines a hold on the selected cube cell.
  • Hold Manager:
    Starts the Hold Manager of the selected cube cell.
  • Jedox Error:
    If a PALO function displays an error in a cell, then you can use this menu item to get additional error messages.
Was this post helpful?
NoYes (+2 rating, 2 votes)