After a successful Jedox installation and a restart of Excel you will see in Excel 2010/2013/2016 the Jedox Ribbon:
Jedox Ribbon items:
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.
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.
- Undo Options:
Here you can select a range of a Jedox view for which you can take back changes gradually or as a whole.
- Splashing Wizard:
This wizard simplifies the entries for “General splashing”, ” Copy/Like/Predict splashing”, and “Goalseek splashing”.
- Lock Jedox cell:
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”
Tab “Dialog options”
Tab “Modeler options”
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.
- Jedox Error:
If a PALO function displays an error in a cell, then you can use this menu item to get additional error messages.