4th February 2026: We’re happy to release our Open Source BI Helical Insight version 6.1.0.826 in February 2026. In this blog, we are going to explain all the new features that have been introduced with our newer version.

Backend technology upgrade

  1. Java:From version 6.1.0.826, we have upgraded Helical Insight to Java 25, which has the latest LTS (Long Term Support).

  2. Tomcat Upgrade: Further, Helical Insight by default comes with Tomcat. The same was previously on Tomcat 9 which has been upgraded to Tomcat 10 from version 6.0. With the latest release, we have upgraded to Tomcat 11.

  3. Similarly, all other 3rd party libraries like hibernate, spring, maven etc have also been upgraded.

Data Sources

  1. Multiple JDBC URL Formats Support: In this version, we’ve updated our JDBC configuration capabilities to support multiple database URL patterns, like backslash semicolon etc formats that are used by certain databases. Many databases support multiple URL formats, This can be accessed and configured through Advanced Options and you will get a drop down option allowing you to select which kind of URL it should create.

  2. Walkthrough of Open Source BI Helical Insight version 6.1.0.826

  3. Postgress JDBC Driver: The latest release automatically includes the most up-to-date PostgreSQL JDBC driver, reducing setup effort and ensuring seamless PostgreSQL database connections.

Reports

  1. UI UX Simplicity: In the previous versions, to create certain visualizations multiple clicks and steps were required like selecting visualization, going to Marks, clicking drop down etc. We’re working on simplifying the specific UI/UX to enable creating visualizations with single/fewer clicks.

    From the latest released version, you are able to create Visualizations with less number of clicks or even, with a single click. This is more prominent for use cases like KPI cards, trend charts, and widget cards.

  2. Walkthrough of Open Source BI Helical Insight version 6.1.0.826

    Walkthrough of Open Source BI Helical Insight version 6.1.0.826

    Walkthrough of Open Source BI Helical Insight version 6.1.0.826

  3. Chart Hover Details: In the updated version, when you hover over any visualization, you can now see how many measures and dimensions are required for that visualization.

  4. Walkthrough of Open Source BI Helical Insight version 6.1.0.826

    Walkthrough of Open Source BI Helical Insight version 6.1.0.826

  5. Enable/Disable Chart: Based on the number of measures and/or dimensions that you drag, visualizations that do not meet the required number of measures or dimensions criterion are automatically disabled, thus elevating the user experience and avoiding any confusion.

  6. Walkthrough of Open Source BI Helical Insight version 6.1.0.826

    Walkthrough of Open Source BI Helical Insight version 6.1.0.826

  7. Trend Card Properties: When you create a trend card, in this version, more properties (Prefix and Position) have been added. Once the visualization is selected and when you go to card properties, you can see the newly added properties.

    Walkthrough of Open Source BI Helical Insight version 6.1.0.826

    Walkthrough of Open Source BI Helical Insight version 6.1.0.826

    Trend prefix by default is “vs” which can be changed as per your requirement and the position can be selected as center or start or end.

  8. Walkthrough of Open Source BI Helical Insight version 6.1.0.826

  9. Card Subchart Sizing: In the earlier versions, subcharts within card visualizations appeared very small, making them harder to understand. With the latest update, subcharts are present in full container size and are made responsive, thus improving the readability. When you export the report as well, the subcharts now appear in a larger size , thus are easier to read and understand.

  10. Walkthrough of Open Source BI Helical Insight version 6.1.0.826

  11. OpenStree Map support: Earlier, map visualizations required access to Mapbox Pro, which is a paid charting engine. Users had to purchase and configure a separate license within Helical Insight.

    With the latest update, we’ve added support of OpenStreetMaps (OSM) as well, that can be configured and used as well, allows users to create map visualizations.

  12. Calendar Chart: A new charting option, Calendar visualization has been added in the latest release. This enables easy date-wise comparisons, to analyze patterns and trends across days at a glance.

  13. Walkthrough of Open Source BI Helical Insight version 6.1.0.826

Canned Reports

    This is the module that allows to create Paginated multi pager pixel perfect document kind of canned reports like bank statements, salary slips, invoices etc. Canned Reporting module was introduced in our Version 6.0 and we’ve been working on enhancing and adding new capabilities in the module.

  1. Elements: Along with older elements like Image, Text, Line etc more element support options have been added like Table, Cross Tab and Chart are added in the latest update.

    Walkthrough of Open Source BI Helical Insight version 6.1.0.826

    Walkthrough of Open Source BI Helical Insight version 6.1.0.826

    i) Table: Allows users to present data in a simple, structured tabular format by directly selecting the Table component. This enables users to organize data into rows and columns easier. This supports displaying multiple fields together, helping users view complete information in one place. In a single report, you can also put multiple Tables and each Table can get data from different SQLQuery.

    Walkthrough of Open Source BI Helical Insight version 6.1.0.826

    There are various configuration options available for Table element which can be configured from the property pane appearing on the right side of the canvas. Here, the user can selects the fields for the table, fields for table column etc.,

    Walkthrough of Open Source BI Helical Insight version 6.1.0.826

    ii) Cross Tab: The Cross Tab element allows users to view data in a multi-dimensional, matrix-style format. Now a cross tab can be easily created in a report by directly dragging the Cross Tab element onto the canvas and giving respected rows and columns.

    Walkthrough of Open Source BI Helical Insight version 6.1.0.826

    The cross tab has various configuration options like what fields to be selected and what fields can be applied as rows or columns or measures etc., User can select the fields as per their requirement from the property pane.

    Walkthrough of Open Source BI Helical Insight version 6.1.0.826

    iii) Chart: The Chart element enables users to represent data visually using various chart types by directly selecting the element. This helps making insights easier to understand and interpret.

    Walkthrough of Open Source BI Helical Insight version 6.1.0.826

    There are various configuration options available for chart element where you can select the type of chart to be used, category, value etc. These are available in the property pane on the right side of the canvas, once the element is selected.

  2. Walkthrough of Open Source BI Helical Insight version 6.1.0.826

  3. Single select option UI Change: In canned report,the single select option is now displayed as a radio button (similar to what we have in adhoc designer and dashboard) thus making the UX consistent across all modules. Earlier, in canned report both single-select and multi-select options used the same interface, which could be confusing.

    This helps improve consistency in the UI and makes selection behavior more easier to understand.

  4. Report Properties: In the Canned Reports module, we’ve introduced Report Properties option that allows users to edit and configure report-level settings. These properties control the overall behavior, layout, export behaviour and runtime of a report by defining parameters such as spacing between rows/columns, header/footer settings, enable/disable pagination, caching options. The report properties can be seen in the Property Pane on the right side of the canvas, making them easy to access and modify while designing reports.

    Walkthrough of Open Source BI Helical Insight version 6.1.0.826

    A set of default properties is already defined and can be easily toggled or adjusted based on specific requirements.

    Walkthrough of Open Source BI Helical Insight version 6.1.0.826

    Walkthrough of Open Source BI Helical Insight version 6.1.0.826

    In addition, users can add and configure their own settings through user-defined Properties, offering greater flexibility and control over how reports are structured.

Print Framework

In the Canned Reporting module, users can already define paper orientation (Landscape or Portrait) and paper size at the report level, and the layout is exported or printed accordingly.

We’ve now working on adding this capability to allow chart (ad-hoc report) and dashboard exports to follow specific orientation and size settings.

For now these settings have to be configured from the backend, and the selected orientation and paper size are applied consistently across all charts/dashboards. This ensures better control over export layouts and output formatting.

Also, we’re actively working toward making these settings fully UI-driven, thus for each dashboard and chart you can specify what export settings it should use.

Bug Fixes

  • Date range picker at the dashboard level in free float mode was not working earlier and it is fixed now.
  • In the Trino Database connection, when multiple dates was used at the filter level, there were few issues showing which has been fixed now.
  • Minor bugs across various modules (dashboard designer, report designer, Canned reports, data sources) have also been fixed.

Please reach out on support@helicalinsight.com in case of any questions, POC, demo or further questions. Register and download for free from here.

Leave a Reply

Helical Insight’s self-service capabilities is one to reckon with. It allows you to simply drag and drop columns, add filters, apply aggregate functions if required, and create reports and dashboards on the fly. For advanced users, the self-service component has ability to add javascript, HTML, HTML5, CSS, CSS3 and AJAX. These customizations allow you to create dynamic reports and dashboards. You can also add new charts inside the self-service component, add new kind of aggregate functions and customize it using our APIs.
Helical Insight’s self-service capabilities is one to reckon with. It allows you to simply drag and drop columns, add filters, apply aggregate functions if required, and create reports and dashboards on the fly. For advanced users, the self-service component has ability to add javascript, HTML, HTML5, CSS, CSS3 and AJAX. These customizations allow you to create dynamic reports and dashboards. You can also add new charts inside the self-service component, add new kind of aggregate functions and customize it using our APIs.
Helical Insight, via simple browser based interface of Canned Reporting module, also allows to create pixel perfect printer friendly document kind of reports also like Invoice, P&L Statement, Balance sheet etc.
Helical Insight, via simple browser based interface of Canned Reporting module, also allows to create pixel perfect printer friendly document kind of reports also like Invoice, P&L Statement, Balance sheet etc.
If you have a product, built on any platform like Dot Net or Java or PHP or Ruby, you can easily embed Helical Insight within it using iFrames or webservices, for quick value add through instant visualization of data.
If you have a product, built on any platform like Dot Net or Java or PHP or Ruby, you can easily embed Helical Insight within it using iFrames or webservices, for quick value add through instant visualization of data.
Being a 100% browser-based BI tool, you can connect with your database and analyse across any location and device. There is no need to download or install heavy memory-consuming developer tools – All you need is a Browser application! We are battle-tested on most of the commonly used browsers.
Being a 100% browser-based BI tool, you can connect with your database and analyse across any location and device. There is no need to download or install heavy memory-consuming developer tools – All you need is a Browser application! We are battle-tested on most of the commonly used browsers.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
A first-of-its-kind Open-Source BI framework, Helical Insight is completely API-driven. This allows you to add functionalities, including but not limited to adding a new exporting type, new datasource type, core functionality expansion, new charting in adhoc etc., at any place whenever you wish, using your own in-house developers.
A first-of-its-kind Open-Source BI framework, Helical Insight is completely API-driven. This allows you to add functionalities, including but not limited to adding a new exporting type, new datasource type, core functionality expansion, new charting in adhoc etc., at any place whenever you wish, using your own in-house developers.
It handles huge volumes of data effectively. Caching, Pagination, Load-Balancing and In-Memory not only provides you with amazing experience, but also and does not burden the database server more than required. Further effective use of computing power gives best performance and complex calculations even on the big data even with smaller machines for your personal use. Filtering, Sorting, Cube Analysis, Inter Panel Communication on the dashboards all at lightning speed. Thereby, making best open-source Business Intelligence solution in the market.
It handles huge volumes of data effectively. Caching, Pagination, Load-Balancing and In-Memory not only provides you with amazing experience, but also and does not burden the database server more than required. Further effective use of computing power gives best performance and complex calculations even on the big data even with smaller machines for your personal use. Filtering, Sorting, Cube Analysis, Inter Panel Communication on the dashboards all at lightning speed. Thereby, making best open-source Business Intelligence solution in the market.
With advance NLP algorithm, business users simply ask questions like, “show me sales of last quarter”, “average monthly sales of my products”. Let the application give the power to users without knowledge of query language or underlying data architecture
With advance NLP algorithm, business users simply ask questions like, “show me sales of last quarter”, “average monthly sales of my products”. Let the application give the power to users without knowledge of query language or underlying data architecture
Our application is compatible with almost all databases, be it RDBMS, or columnar database, or even flat files like spreadsheets or csv files. You can even connect to your own custom database via JDBC connection. Further, our database connection can be switched dynamically based on logged in users or its organization or other parameters. So, all your clients can use the same reports and dashboards without worrying about any data security breech.
Our application is compatible with almost all databases, be it RDBMS, or columnar database, or even flat files like spreadsheets or csv files. You can even connect to your own custom database via JDBC connection. Further, our database connection can be switched dynamically based on logged in users or its organization or other parameters. So, all your clients can use the same reports and dashboards without worrying about any data security breech.
Our application can be installed on an in-house server where you have full control of your data and its security. Or on cloud where it is accessible to larger audience without overheads and maintenance of the servers. One solution that works for all.
Our application can be installed on an in-house server where you have full control of your data and its security. Or on cloud where it is accessible to larger audience without overheads and maintenance of the servers. One solution that works for all.
Different companies have different business processes that the existing BI tools do not encompass. Helical Insight permits you to design your own workflows and specify what functional module of BI gets triggered
Different companies have different business processes that the existing BI tools do not encompass. Helical Insight permits you to design your own workflows and specify what functional module of BI gets triggered