Depending on the complexity of a workbook, you need to decide whether data in the workbook is calculated automatically or manually. You can select these options in the Formulas menu:
The option Automatic calculation is enabled by default after starting a Jedox session and normal calculations, such as the SUM() function, are immediately recalculated when you change a cell in the area of the sum.
If you uncheck Automatic calculation, such functions will not immediately be recalculated. In this case, writeback to the In-Memory DB and usage of the dialogs for Planning Assistant, Cell Tracer, Drillthrough, and Setting Holds and Using the Hold Manager are not supported.
The button Recalculate starts once the recalculation of the whole spreadsheet.
If you check Periodic refresh, you can specify the interval in seconds by which data is auto refreshed.
Note: for performance reasons you should not specify a refresh interval of under 10 seconds.
Refresh applies to all functions that are not refreshed continuously, such as PALO.DATA(), RANDOM NUMBER(), TODAY(), etc.
In contrast,
Recalculate executes once the calculation for every click, while Periodic refresh is continuously carried out. The setting of the Periodic refresh checkbox is saved with the file.
Automatic calculation is enabled by default in Jedox Web for Reports and Designer. Within any given session, any changes to the Automatic calculation checkbox in one of these components apply to all open files within both components.
This option is only temporarily set for the current workbook Jedox Web session (e.g. to prevent unwanted recalculations during the designing phase of the report). As soon as an additional / other workbook is opened, Automatic calculation will be enabled again for all open reports to ensure proper loading of the new workbook.
Updated September 25, 2024