From the Custom Reports section, you can create custom reports by integrating real-time data values from Jedox's In-Memory DB directly into Excel 365.
Insert Element
The Insert Element button allows you to insert one element with its name or, if available, its alias.
Clicking on the element will open the task pane where you can edit and update the selection.
Data Function
After you have inserted related elements, you can use the Data Function button to display their value from the database cube into a spreadsheet cell, or to write the value of a spreadsheet cell back into the database cube.
You can also access attribute cubes by activating the option in the settings. Watch the video on how to access them from custom reports.
This feature utilizes the PALO.DATAC, PALO.DATAV, PALO.SETDATA, and PALO.SETDATAIF functions.
Guess arguments
The "Guess arguments" functionality automatically refers to cells on your sheet that contain potential arguments for the PALO.DATAC function. Double-click the cell with the value to display the referenced arguments.
This function can only search within a range of 20 columns above and 20 rows to the left of the position where the PALO function was inserted.
Watch the video on how to insert data functions. Note that the video was recorded with an earlier version, but the functionality has remained the same.
In addition, the calculations of the PALO functions have been adapted to Excel's calculation options (automatic, partial, manual) for enhanced writeback performance.
Did you know...
- You can insert more than one element of the same dimension at once. See Jedox Dynamic Array in Add-in for Excel 365.
- You can also create Jedox Views which ca be saved as Word type and accessed, displayed, and updated in the Add-in for Word 365.
- Learn also more about the add-in's Features
Updated March 31, 2025