Here you'll find the latest updates to Knowledge Base content.
January 2025
Consolidation Dimension
The article has been updated to include all the elements of the Consolidation dimension.
DynaRanges
A workaround has been added for the "Parents Below Children" constraint in DynaRanges, using the INDIRECT function to ensure dynamic cell references adjust correctly.
Disaster Recovery Service
The article has been updated for clarity and consistency.
Known Issues in Jedox 2024.2
Known issues updated January 24, 2024.
Conditional Formatting
Information about removing specific formats from conditional rules has been added to the article.
Subsets
The Subset section has been significantly improved to enhance the user experience. Additionally, some sections of the Subsets Overview article have been reorganized to make three dedicated articles, each focusing on specific areas: General Tab in the Subset Editor,Text Tab in the Subset Editor , Picklist Tab in the Subset Editor.
What's New Models
The article has been updated to include the latest enhancements and features.
Updating the Financial Consolidation Model
A note highlighting the differences between installation and updates has been added to the article.
Financial Consolidation Release Notes
The Financial Consolidation version 2.7.5275 has been released, featuring Staging Area and Merge Equity as new additions.
December 2024
The following articles have been extensively revised and updated to reflect the latest version of the Add-in for Excel 365:
Quickstart with Add-in for Excel 365
Features in Add-in for Excel 365
Views in Add-in for Excel 365
Custom Reports in Add-in for Excel 365
Known Issues in Add-in for Excel 365
Excel Add-ins FAQ
Add-in for Word 365 (preview feature) new
Jedox Status
Updated the Availability graph.
Known Issues in Jedox 2024.2
Known issues updated December 13, 2024.
Naming Conventions for Jedox Objects
A restriction on rule syntax has been added, specifying that rules cannot begin with a space.
Autosave in Jedox
Article has been renamed and updated. The URL for the article has also changed.
REST Connection
For REST connections with HTTP mode POST, PUT, PATCH or DELETE, the default encoding of a request body is UTF-8. If the web service only accepts requests with the body encoded in ISO-8859-1, you can add ; charset=iso-8859-1 to the Content-Type header, like text/xml; charset=iso-8859-1.
November 2024
Connecting to an FTP Location
Active mode in FTP connections is no longer supported in Jedox Cloud. For customers who are upgrading from Jedox on-prem to cloud, see Migrating FTP connections from Jedox On-Prem.
Dynatables
This article has been updated to include new information on using stored Subsets as a source, disabling empty dimensions, and deleting Dynatables.
Connecting to a OneDrive Location
Additional detail on using a token endpoint for OAuth2 token has been documented.
Systems Supported by Jedox Integrator
Article has been updated with the latest supported versions.
PowerBI Load
"Create" mode has been deprecated due to changes in Microsoft. A warning will now be raised when attempting to run PowerBI Load with mode "create". See also Deprecations and Breaking Changes.
Deprecations and Breaking Changes
R services for the AIssisted™ Time Series Prediction Wizard will be deprecated as of version 25.1.2.
PGP Decryption in File-Based Connections
PGP decryption, supported with 2024.2, enables users to securely decrypt files that have been encrypted with PGP (Pretty Good Privacy) directly within the platform. Connections that support PGP decryption are CSV, ExcelFile, JSON, Parquet, and XML. For details on adding a private key to a Jedox instance, see Keys and Secrets.
Financial Consolidation Release Notes
The Financial Consolidation Model 2.6.5252 is here! Read about the latest changes.
Financial Consolidation Known Issues
Known issues updated November 5, 2024.
Importing and Exporting PB and WSS Files
This article has been extensively revised and updated to ensure accuracy and relevance.
Subsets Overview
Updated the "Constraints" section.
Batch Export Storage Types
The article has been updated for clarity and consistency. The name of the article was previously "Scheduler Storage Types".
Emails and Notifications
Added information on how to register the Microsoft Graph app on Azure.
JedoxAI FAQ new
This article outlines the FAQs about JedoxAI, covering topics such as how to use it, performance, integration, and security.
Features in JedoxAI new
This article provides details on all JedoxAI's features and how to get the best of them.
JedoxAI
The article has been updated to reflect JedoxAI's new functionalities.
October 2024
Known Issues in Jedox 2024.2
Known issues updated October 30, 2024.
Jedox Version Auto-Update
Deployment for Jedox 24.2 will begin on October 21, and customers wishing to reschedule their update now have 60 days to do so.
Native Components to Canvas
Dynatables, now integrated into Canvas, allow Analysts, Super Planners, and End Users to easily create, explore, and interact with real-time analytics and tabular data through an intuitive drag-and-drop interface.
Patch release for the Add-in for Excel 365. Clear your cache to ensure that the update is applied.
Fall 2024
Autumn 2024 Major Release (2024.2) and Cloud Console Release Notes
Jedox 2024.2 is here! Read about the latest changes.
Click to copy links in the Jedox Knowledge Base
Most headings in the KB now display a link icon 
when you hover over them. Clicking the icon copies the URL for that location, making it easy to share or bookmark KB content.
The Jedox Fall 2024 release features integration with Parquet. The following new articles describe the setup for each Integrator component:
Parquet Connection new
Parquet Extract new
Parquet Load new
SAP Organizational Unit Extract new
This new article explains the settings for this SAP extract.
Connecting to an SFTP Location
Added information on using private key and testing fingerprint when connecting to SFTP file locations.
Cube Load
Added clarification on how holds on cells can affect delete mode.
Added required permissions for connections to Sharepoint, OneDrive, and Power BI locations.
September 2024
Known Issues in Jedox 2024.2
Known issues updated September 26, 2024.
Dynatables
To open Dynatables directly from the Jedox Web UI, users can use the keyboard shortcut "Alt + T" on Windows or "Option + T" on macOS.
Deprecations and Breaking Changes
Added a deprecation / breaking change: Adjusting Email notifications via SMTP in Jedox Web
Jedox Status
Updated the Availability graph.
Excel Add-ins FAQ new
This article outlines the FAQs that can be helpful for a smooth switchover from Excel COM Add-in to Add-in for Excel 365.
The following articles have been updated to reflect the latest version of the Add-in for Excel 365:
Quickstart with Add-in for Excel 365
Features in Add-in for Excel 365
Views in Add-in for Excel 365
Custom Reports in Add-in for Excel 365
Known Issues in Add-in for Excel 365
Custom Configurations for the In-Memory DB (OLAP)
Two new configuration options, string-storage-rebuild-limit and string-storage-rebuild-schedule, have been released. These options can be used to ensure fast retrieval and processing of large data volumes. Note that any configuration changes to your Jedox Cloud environment must be coordinated with Jedox Support.
Known Issues in Jedox 2024.1
Known issues updated September 2, 2024.
August 2024
Support Lifecycle
As of August 29, 2024, Jedox version 2023.3 is no longer supported.
OLAP String Storage and its Usage in Jedox new
This article outlines the specifics of the current string storage in Jedox OLAP, as well as its limitations and recommended best practices.
Cloud Console Release Notes
New time frame selection for displaying the Statistics graphs.
Jedox Status
Updated the Availability graph.
Actual months
The Actual Months template description now clarifies the behavior for fiscal-year queries.
Cloud Console Release Notes
Technical improvement for the instance synchronization.
Adding Native Components to Canvas
Two notes have been added to the Data tab of the Combobox native component, clarifying how "stored Subsets" behave when used in Comboboxes within Canvas.
Financial Consolidation Known Issuesnew
This article provides a list of the fixed known issues in the Jedox Financial Consolidation model.
Financial Consolidation Release Notesnew
This article provides detailed notes on the latest updates and new features in the recent product versions of the Jedox Financial Consolidation model.
Total Divestment Business Transaction Typenew
This article offers detailed information on Divestment Consolidation Rules, including C6 (Direct Owners), C7 (Divestment of Non-Controlling Interests), and several other sections within the Total Divestment Business Transaction Type in the Jedox Financial Model.
July 2024
Known Issues in Add-in for Excel 365
Known issues updated July 29, 2024.
Adding Components to a Canvas
To improve the user experience, this article was divided into Adding Native Components to Canvas and Adding Web Spreadsheet Workbooks Components to Canvas.
Snowflake Connection
Information about OAuthToken authentication to Snowflake has been added.
Connecting to a Sharepoint Location
Description of the Site and Document Library fields has been improved based on customer feedback.
Cloud Console Release Notes
New server log type Access Logs.
Jedox Status
Updated the Availability graph.
Jedox OData Hub Overview
Added information about the data access rights in OData Hub.
Removing Junk Content from Reports new
This new article provides information on manually cleaning the unnecessary content from older spreadsheets.
DynatablesThe article has been updated with the information on the latest Dynatables updates.
Access List for IP Whitelisting
The article has been updated for clarity and consistency.
REGRESSION()
More detailed information on REGRESSION() function was added.
Jedox Licenses
The article has been updated with the current offerings.
Known Issues in Jedox 2024.1
Known issues updated July 10, 2024.
Support Lifecycle
Jedox is reducing the number of major releases per year. See article for details.
June 2024
Removed articles "Quickstart with Excel Add-in" and "Paste View Dialog in Excel Add-in"
The articles have been removed for clarity and consistency. You can find their content in the articles Creating a Jedox View and Paste View Dialog .
Known Issues in Add-in for Excel 365
Known issues updated June 18, 2024.
Jedox Status
Updated the Availability graph.
Caching in Extracts and Transforms
When caching is used in certain types of extracts and transforms, the notation of numeric source values with fixed scale will change. A note was added to explain this behavior.
The following articles have been updated to reflect the latest version of the Add-in for Excel 365:
Quickstart with Add-in for Excel 365 - check out the new connection and login dialog.
Features in Add-in for Excel 365 - replaced the experimental feature "Report buttons" with "Click area".
Views in Add-in for Excel 365 - take a look at the search functionality for the selection of elements within a dimension.
AI Search Help Centernew
This new article provides information about the AI Search Help Center, Jedox's AI-powered assistant. It shows you how to engage with the assistant and clarifies matters such as answer generation and privacy.
JedoxAInew
This new article introduces you to JedoxAI, an in-preview feature which integrates Natural Language Processing (NLP) capabilities into Jedox Views.
Known Issues in Jedox 2024.1
Known issues updated June 14, 2024.
Support Lifecycle
Article has been updated to reflect currently supported versions.
Relational Load
A note regarding SQL data types has been added, and some formatting issues with the example tables were corrected.
May 2024
Dynatables
Users can now sort the different sections of the Dynatable list in ascending or descending order. Furthermore, users can also select elements and aliases in the row and column dimensions of Dynatables.
Dynatables Keyboard Shortcuts new
This new article provides information on available keyboard shortcuts in Dynatables.
Jedox APIs
Links to Jedox APIs have changed. If you have bookmarked any links, please update them. Also changed are links to Macro Engine API.
Known Issues in Jedox 2024.1
Known issues updated May 23, 2024.
Cloud Console Release Notes
Display of the cloud instance's inbound and outbound IP addresses.
Generating a Batch PNG new
This new article provides a step-by-step guide on how to generate Batch PNG.
Scheduling a Task as a Batch PNG new
This new article provides a step-by-step guide on creating a task as Batch PNG.
April 2024
Jedox Patch Updatesnew
This new article provides information about the Jedox software patch deployment.
Jedox OData Hub Connector in PowerBI
Information about troubleshooting data refresh has been added to the article.
Excel COM Add-in Troubleshooting
Added information on the limitation of Add-in usage when running multiple Excel instances at the same time.
Jedox Status
Updated the Availability graph.
Setting Holds and Using the Hold Manager
Information about the limit of holds shown in Hold Manager is added.
Deprecations and Breaking Changes
Two WorkerLogin modes (authorization and authentication) are being deprecated in 2024.2.
Known Issues in Jedox 2024.1
Known issues updated April 15, 2024.
March 2024
Cell Tracer
Added a note on when the Cell Tracer dialog will not be displayed.
Known Issues in Jedox 2024.1
Known issues updated March 25, 2024.
The following articles have been updated to reflect the latest version of the Add-in for Excel 365:
Features in Add-in for Excel 365 - Introducing "Report buttons" as the first Experimental feature
Views in Add-in for Excel 365 - learn about the latest feature Keep Only
Subsets Overview
The article has been updated for clarity and consistency.
Naming Rules for Jedox Objects
Naming rules for Integrator objects were added.
February 2024
Spring 2024 Major Release (2024.1)
Jedox 2024.1 is here! Read about the latest changes.
Dynatables new
Jedox users can now have direct access to In-Memory DB Views within Jedox Web UI, separate from Jedox Web Spreadsheets.
Google Sheets Connection new
Jedox 2024.1 features a new native connection, enabling users to connect and extract data from Google Sheets.
Google Sheets Load new
This new load type allows data to be loaded to Google Sheets through a native Google Sheets connection.
Unmanaged Private Cloud new
This new article provides information about the Unmanaged Private Cloud offering.
Financial Consolidation Model
The Create New Business Transaction, Investment Register Report,and Additional Financial Data Cube articles have been updated, and the Investment Details Report, and Investment Register Business Logic are newly added.
Jedox Web Actions: Set Value
Added a note on the handling of Actions at workbook level during PDF creation.
Systems Supported by Jedox Integrator
Article has been updated with currently supported databases, including Snowflake.
Jedox Version Auto-Update
The article has been updated for clarity.
Managing Databases in Modeler
The "restoring a database" section has been updated for clarity and consistency.
Client Environments Supported by Jedox
The article has been updated for clarity and consistency.
January 2024
Financial Consolidation Model
The Business Transaction Dimension, Additional Financial Data Cube, and Business Transaction Mapping Cube articles have been updated, and the Business Transaction Type Dimension and Create New Business Transaction are newly added.
How to Use the Jedox Knowledge Basenew
This new article provides information on the general structure of the Jedox Knowledge Base and how you can use it effectively.
Jedox Instance Synchronization
Added a note on the use of license seats.
Jedox Status
Updated the Availability graph.
Stored Subsets
Added a note on the behavior of changing the name of a stored Subset.
Jedox OLAP Connection
OLAP connection to an external OLAP server uses port 443.
Special Features in Workflow for Financial Consolidation
The "Reports with workflow-awareness" section has been completely updated.
Sort Tab in the Subset Editor
Information on how to sort by Value with Multiple DFilters has been added to the article.
The following articles have been updated for clarity and consistency:
Importing and Exporting PB and WSS Files
Importing and Exporting XLSX Files in Jedox Web
Snapshot in Excel COM Add-in
Offline Mode for Excel Workbooks
AIssisted™ Planning FAQnew
This new article provides answers to the most common questions about the AIssisted™ Planning model.
Updated January 29, 2025