Known Issues in Jedox 2020.3

Below is a current list of known issues in Jedox. Hotfixes become available on an ongoing basis as issues are resolved. As of version 2019.2, Jedox software is now updated weekly and will include the latest hotfixes. Note that major releases will still take place on a quarterly basis. Hotfixes are available in the Jedox Support Portal.

Click on the table headings below to sort by column.

Known issues in other versions of Jedox:

Updated November 26, 2020

ComponentIDDescriptionStatusFixed In
Excel Add-in44019Pasting a subset with a long formula across several rows and columns results in an error message due to technical restrictions from Microsoft Excel. Workaround: Jedox Excel Add-in inserts the formula in the first cell of the selected range so that it can be used to manually create an array in the desired range.Open
Excel Add-in44557In Excel for Office 365, pasting a subset into a single cell and then expanding it over a range of cells as an array doesn't work due to a recent change in Excel functionality, which inserts an @ into formulas. Workaround: after expanding the cell range, remove the @ operator manually from the formula and press CTRL-SHIFT-ENTER.Open
Excel Add-in42343In some scenarios, a Lost UI error message is displayed in the log. This error message has no impact on the performance.Open
Excel Add-in43332The Element Picker encounters display issues when using the arrows to remove elements from a selection.Open
In-Memory DB47428For users that aren't members of the "admin" group, retrieving Audit data on large cubes in the Administration panel can be slow.Open
Jedox Mobile45511If zooming is disabled in the first report opened in the Jedox Plan and Forecast mobile app, all subsequently opened reports will also have zooming disabled.Open
Jedox Mobile41728Web reports do not scale down properly on Android devices.Open
Jedox Mobile42066When tapping the "Clear cache" button in Settings, there is no visual feedback to indicate that the cache was cleared.Open
Jedox Mobile43352The option to disable "filter by device" is currently not shown if no reports are available.Open
Jedox Web18919The database access rights from cube #_GROUP_DATABASE_DATA are not yet fully utilized in Jedox Web.Open
Jedox Web19534When creating two reverse DynaRanges that are aligned next to each other, expansion doesn't work correctly.Open
Jedox Web21902If the data source for a chart is dynamic (e.g. based on @variables), the chart may not initialize with correct settings and formatting in all cases. Workaround: manually define the options for data structure in "Source Data" dialog.Open
Jedox Web43883Disabling the mail notifications on Scheduler Tasks which were created in Jedox version prior to 2019.* doesn't always work correctly.Open
Jedox Web43975When creating a Batch task that is executed for a single user in versions older than 2019.3, and then, it is not possible to change the "Notifications" for this task anymore in scheduler UI.Open
Jedox Web44618When rebuilding a View in a Web Spreadsheet, a DynaRange in the same sheet cannot be removed.Open
Jedox Web44633After renaming an Integrator project, a file with the old name remains in the recent file list. Clicking on the file leads to a FlowGraph error.Open
Jedox Web44668File icons do not appear in General tab of Properties dialog in the "Designer" panel of Jedox Web.Open
Jedox Web44988When axis labels in charts are wrapped to multiple lines, they appear in PDFs as a single line and partially overlap.Open
Jedox Web45107When removing a dimension from a cube, existing Views on this cube do not show correct result directly. Workaround: open the "Edit View" dialog for this view, and paste it again.Open
Jedox Web45602The default row height in a View Theme isn't correctly preserved after creating a new theme.Open
Jedox Web45623Repeatedly creating new View themes in a running session in Jedox Web doesn't work correctly.Open
Jedox Web45641Importing a View theme with the same name as an existing theme doesn't work correctly.Open
Jedox Web45790Entries in Jedox Web History navigation for Mail Templates in Scheduler aren't set correctly.Open
Jedox Web45827When a primary axis and secondary axis have been set in a chart, fixed values for Min/Max of the chart axis are not used correctly in all cases.Open
Jedox Web46267Using the "Upload" action to upload .wss files doesn't work correctly.Open
Jedox Web46271If a connection in Jedox Web uses uppercase characters in the connection name, it cannot be used correctly in Web spreadsheet dialogs. Workaround: change the connection name to use lowercase characters only.Open
Jedox Web47551When duplicating a function in a FieldTransform, changes to the duplicated function are also applied to the original function. Workaround: save the Integrator project before editing the duplicated function.Open
Jedox Web46433When uploading a file on a dimension in Modeler, changing the level assignment of an attribute doesn't work correctly on the first attempt.Open
Jedox Web46514When defining an Action as the target of a Hyperlink on a Chart, the action is executed twice.Open
Jedox Web46572Spreadsheet cell comments have display issues.Open
Jedox Web46589When defining styles or number formats on List blocks in a database in which no element formats had been previously defined in modeler, the styles / number formats are not stored correctly.Open
Jedox Web46877When setting a style class on an unlocked spreadsheet cell in Jedox Web, the icon indicating the unlocked state in reports mode is not shown anymore.Open
Jedox Web46985When importing a file via the context menu on a root folder in Jedox Web Designer, and a file with the same name exists, the handling for replacing the existing file is not correct.Open
Jedox Web47266In Jedox Web, when pasting a previously copied folder into this folder itself, the operation is not processed correctly, making this folder inaccessible afterwards.Open
Jedox Web47309When creating new Lists from the Paste View dialog, and using a name for the List which is already used for a Dimension, the behavior is not correct.Open
Jedox Web47411When detaching a View using System database or user / group dimensions, the detached view shows errors in some scenarios.Open
Jedox Web47478Users that are not members of the "admin" user group cannot properly change the group assignments of other users, even if their own role rights permit them to.Open
Jedox Web47717When using Chrome Browser version 87, the Jedox Web Login page is not displayed correctly.Open20.4.0
Jedox Web33373When a user belongs to multiple groups with different access rights to Folders in Report Hierarchies, the user rights are not correctly applied after setting them the first time. Workaround: when re-setting the user right, it is correctly stored.Open
Jedox Web39444PDF Export of Widgets in web spreadsheet doesn't always work correctly if Jedox Web is accessed via TLSOpen
Jedox Web41135Searching in a nested dimension in Modeler causes the following OLAP error: "Error while loading elements".Open
Jedox Web41192Enabling Designer Preview on a workbook with DynaRanges or the preview option in Paste View logs a false-positive workbook load message in the log file of Spreadsheet Server.Open
Jedox Web41651When exporting and importing an XLSX file containing a bubble chart, the chart does not display properly due to incorrect interpretation of the data source. Workaround: after an XLSX import, set the data source again.Open
Jedox Web41800The Large Subset checkbox becomes deselected when switching from Formula to Subset and from Formula to ODBC query.Open
Jedox Web41869When creating a ComboBox, you cannot include an element in a target cell if its name starts with a "+" character.Open
Jedox Web42296Importing a workbook that has the same name as an existing one via drag and drop takes a long time if you opt out of replacing the existing document.Open
Jedox Web42321The Undo functionality does not work properly after switching between the elements of a ComboBox.Open
Jedox Web42336In some scenarios, Dynamic styles are incorrectly displayed in a report with unlocked cells.Open
Jedox Web42662Using ad hoc calculations for the Header dimensions of a View doesn't work correctly when a stored subset is set for the dimension.Open
Jedox Web42866In the UI for Jedox Integrator, when the browser is resized to a smaller size, some tabs overlap and the FlowGraph pane overlaps the Settings Panel.Open
Jedox Web43101If there are neither row nor column dimensions in Paste View and zero suppression is enabled, editing the view by adding the dimensions to rows/columns will disable zero suppression.Open
Jedox Web43525In the navigation tree in Jedox Web Designer, files cannot be dragged and dropped into the parent folder of their current location.Open
Jedox Web43539For Button form elements in Web spreadsheets, the "No color" option in color picker does not work as expected.Open
Jedox Web43600In Jedox Web Designer, when dimensions of the file selector are larger than the file thumbnail icon, the keyboard delete function does not work.Open
Jedox Web16423In some scenarios, a pop-up message regarding conversion of workbooks is shown when opening a workbook, even though it was already saved in the current version.Open
Jedox Web16837When using a recursive named range (i.e. named range that refers to itself), Spreadsheet Server can become unstable.Open
Jedox Web25034Cell borders of merged cells are not exported to PDF when the print area touches merged cell area. Workaround: Increase print area to cover merged cells completely.Open
Jedox Web26266When using references for parts of PALO.ESELECT() formula, the element picker overwrites references with static values when changing the element selection.Open
Jedox Web27957Web spreadsheet size increases after inserting cells in specific scenarios.Open
Jedox Web28024Conditional formatting on DynaRanges using the "Parents below children" option doesn't always work correctly.Open
Supervision-Server44317If all workers are occupied AND "use-dimension-worker" is enabled, workbooks cannot be created or opened in Designer and an error message ("Unable to load workbook") is thrown.Open
Excel Add-in46576Expanding elements in a View with the "Parents below children" option doesn't always work correctly in Excel Add-in.Fixed20.3.2, 20.4.0
Excel Add-in46695In Jedox Excel Add-in, Views that generate a large number of rows and/or columns can perform slower in version 2020.2.Fixed20.2.4, 20.3.0
Excel Add-in47039On Windows Server OS with Office 365 Update 2008, several actions like recalculation of a view can lead to Excel Add-In becoming unstable. Solution is to update Office to Update 2009.Fixed20.4.0
In-Memory DB46609When using spreadsheets that contain a combination of PALO.DATA.AVG|CNT|MIN|MAX functions and PALO.EL functions, Jedox Excel Add-in or Jedox Web can become unstable.Fixed20.3.1, 20.4.0
In-Memory DB44979Deleting a user group that has "admin" user as member doesn't work properly.Fixed20.3.0
In-Memory DB45164The PALO.VIEW.TABLE function doesn't return Alias values if an Alias is defined for one of the dimensions in the View.Fixed20.4.0
In-Memory DB45897When multiple elements in a dimension are moved in parallel by different users, and elements are also added to or deleted from the dimension at the same time, the structure of the dimension can sometimes be blocked against further changes. Workaround: restart Jedox In-Memory DB server after the problem occurs.Fixed20.1.Q, 20.3.0
In-Memory DB46731When using additive splashing of a percentage value on an empty consolidated cell, the result is not correct in Jedox In-Memory DB 20.1.Fixed20.1.R, 20.2.10, 20.3.1, 20.4.0
In-Memory DB47101When using the function =USERGROUPS() in a Web spreadsheet, a session-related warning is generated in the log file for the In-Memory DB once this report is loaded or recalculated.Fixed20.4.0
In-Memory DB47180A change of the "rights" right object for an existing user role doesn't take effect until the In-Memory DB server is restarted.Fixed20.4.0
In-Memory DB40440Scheduled backups of large databases reach a timeout after 20 minutes. Workaround: exclude CSV files from the generation of the backup or increase the timeout setting.Fixed20.3.0
In-Memory DB42144When a Database Script writes numeric values into cube cells of type string, the cube storage isn't correct in all cases afterwards.Fixed20.2.4, 20.3.0
Integrator45686When the response code "204" (no content) is received from the endpoint of a REST conenction in Jedox Integrator, this incorrectly leads to the execution of the job failing in Jedox Integrator 20.1.Fixed20.1.H, 20.2.2, 20.3.0
Integrator45835Leading or trailing space characters are incorrectly trimmed from the value of project variables.Fixed20.3.0
Integrator46210When using connections to files in the "Designer" location (JedoxFiles), the internal session used for this connection is not closed correctly in Jedox Integrator 20.1 A or newer.Fixed20.1.I, 20.3.0
Integrator46308Project validation and Flow Graphs are not always executed correctly when the connection status of a global Jedox connection changes.Fixed20.4.0
Integrator46312When enabling the optional "Java Security Manager" configuration on Windows, the Jedox Suite Tomcat cannot be started correctly.Fixed20.4.0
Integrator46322For some numeric values retrieved in extracts of type "Excel" the number format is incorrectly changed to scientific format in Jedox Integrator 20.2.Fixed20.2.9, 20.3.2, 20.4.0
Integrator46700The sort order of elements in a dimension is not correct in all cases when using the load mode "insertParallel" in Jedox Integrator 20.2.Fixed20.2.9, 20.3.1, 20.4.0
Integrator46983Sending e-mails as part of a job execution of type "Groovy" doesn't work correctly in Jedox Integrator 20.3.Fixed20.3.3, 20.4.0
Integrator47300In Jedox Integrator 20.2, incoming values in exponential format with a decimal are not always correctly processed in Groovy scripts.Fixed20.2.12, 20.3.7, 20.4.0
Integrator47490On Windows installations of Jedox Integrator 20.3, R-Script transforms cannot be executed correctly.Fixed20.3.10, .0
Integrator47543In Dimension loads using the mode "InsertParallel", if a child element already had multiple parents before the Dimension load, in Jedox Integrator 20.3 the new consolidations of the source data have precedence over the existing consolidations in the dimension.Fixed20.3.10, 20.4.0
Integrator47572When using caching in extracts in parallel job executions, the result is not always consistent.Fixed20.3.9, 20.4.0
Integrator47573In Jedox Integrator 20.3, connections to Access databases don't work if the database contains tables with date/time columns.Fixed20.4.0
Integrator47608Decimal values smaller than 1 that do not have a leading 0 before the decimal separator are not handled correctly in Jedox Integrator 20.2.Fixed20.3.10, .0
Jedox Web44605When using the "Hide headers" ribbon option on a View in Reports, some rows of the header are not correctly hidden.Fixed20.4.0
Jedox Web44637Pictures of all types (png, jpg, gif) and dynamic charts in spreadsheets are not exported to HTML.Fixed20.4.0
Jedox Web44712In Designer, expanding a view with 3 column and 3 row dimensions results in #VALUE! error in Jedox Web 20.1.Fixed20.3.0
Jedox Web45316When trying to rename a duplicated component in an Integrator project, an error message can occur.Fixed20.2.5, 20.3.0
Jedox Web45676When inserting a new function in a transform of type TreeElement in Integrator, the project cannot be saved properly afterwards in Jedox Web 20.1.Fixed20.2.5, 20.3.0
Jedox Web45812When opening the user preview of a Jedox Web spreadsheet, source formulas of named ranges are adjusted incorrectly.Fixed20.1.K, 20.2.7, 20.3.0
Jedox Web45861When using SAML authentication, the logout procedure in Jedox Web 20.2 doesn't work correctly, not showing the logout page.Fixed20.2.2, 20.3.0
Jedox Web46020Spacer elements in stored subsets are incorrectly displayed in views when an attribute or alias is used.Fixed20.4.0
Jedox Web46026Views on cubes in the System database don't work correctly in User Mode in all cases.Fixed20.1.N, 20.2.7, 20.3.4, 20.4.0
Jedox Web46177Editing a subset formula which uses absolute cell references like "$A$1" doesn't work correctly in the Subset Editor in Jedox Web.Fixed20.3.8, 20.4.0
Jedox Web46220In some Views in Jedox Web, the selection or display of elements for some dimensions (such as the #_GROUP dimension) doesn't work correctly.Fixed20.2.7, 20.3.0
Jedox Web46280When navigating via the Flow Graph in complex Integrator Projects, the target component isn't always selected properly in the project navigation tree in Jedox Web 20.1.Fixed20.2.8, 20.3.5, 20.4.0
Jedox Web46281The selection of the "mode" for a Salesforce load doesn't work correctly in the Integrator UI in Jedox Web.Fixed20.4.0
Jedox Web46293Data Preview in Integrator can sometimes lead to error messages that require logging out of Jedox.Fixed20.1.J, 20.2.5, 20.3.0
Jedox Web46378Selection of specific elements on rows or columns of a View in Jedox Web is not preserved correctly when changing the "Use element name path" View option.Fixed20.4.0
Jedox Web46435When using an Integrator Action on a form element inside of a Model that is installed in a namespace, the Action will not execute the correct Integrator Job.Fixed20.3.4, 20.4.0
Jedox Web46479Deleting custom-generated settings in the Settings Manager doesn't always work properly.Fixed20.3.2, 20.3.0
Jedox Web46494The Integrator Action incorrectly allows the use of non-static values in the Project field.Fixed20.3.4, 20.4.0
Jedox Web46565Detaching a View in a Jedox Web spreadsheet imported from an XLSX file doesn't always work correctly.Fixed20.3.0
Jedox Web46598When using a download or Upload Action on a form element inside a Model that is installed in a namespace, the Action will not set the correct target file location.Fixed20.3.4, 20.4.0
Jedox Web46647Using the "Edit template" option in Reports doesn't correctly open the Designer component of Jedox Web.Fixed20.4.0
Jedox Web46693When moving a dimension in the Paste View dialog from rows or columns to the header section, the View does not correctly show data in Jedox Web 20.3.Fixed20.3.2, 20.3.0
Jedox Web46883In Jedox Web 20.3, if no value is defined for the Username of SMTP Server in the Settings Manager, the field to set a value is not shown.Fixed20.3.4, 20.3.0
Jedox Web46897Some Model settings may not be shown correctly in the Administration component.Fixed20.3.4, 20.4.0
Jedox Web46906In some languages, the button to delete a custom logo or icon is not shown properly in the Jedox Web Settings Manager.Fixed20.3.4, 20.3.0
Jedox Web46956On Windows installations, when renaming a root folder in Jedox Web 20.1 or newer and only changing the character case of the root folder's name, the storage on file system for the root folder is deleted.Fixed20.4.0
Jedox Web47242When making inputs on multiple cells with PALO.DATA*() formulas in Reports mode where the inpout cells intersect with a "Freeze Pane" border, input doesn't work correctly In Jedox Web 20.1.Fixed20.4.0
Jedox Web47308In non-english locales, passing dynamic Variables to "Actions" doesn't work correctly.Fixed20.3.6, 20.4.0
Jedox Web47371When editing a rule in the rule list in Modeler, and saving the changes, the list is automatic scrolled to the top instead of keeping the current position.Fixed20.3.8, 20.4.0
Jedox Web47512In Jedox Web 20.1, when using the Administration panel and trying to open the user settings for a specific user, the dialog shows the settings for the current user instead.Fixed20.3.0
Jedox Web35665In Jedox Web, creating a "hold" on Views with hidden header dimension(s) fails with an error message.Fixed20.4.0
Jedox Web40834In the Subset Editor's Hierarchy tab, the Siblings option in a Cyclic list does not remain selected after saving the subset.Fixed21.1.0
Jedox Web42178The HIDEROW() function inside a DynaRange does not work in User Mode in all scenarios. Rather than hiding the row, it shows the actual "TRUE" value.Fixed20.1.H, 20.3.0
Jedox Web42293Warning messages are logged in the Scheduler server log after installing a model from the Jedox Marketplace and executing a task in the Scheduler.Fixed20.4.0
Jedox Web42322Using a comma character in the name of a stored subset can cause issues when trying to detach a view that uses this subset.Fixed20.4.0
Office Add-in47216Due to changes in office 365 update 2009, Office Add-In becomes unstable when adding new placeholders or when updating existing ones. Solution: Upgrade Office 365 from update 2009 to update 2010.Fixed20.4.0
Windows Setup46644If a Hotfix for Jedox Web RPC had been previously installed in a Windows environment, the content of the RPC component may not be correct after an update to 20.3, potentially leading to various issues in Jedox Web.Fixed20.4.0