Open Source Business Intelligence Platform

Helical Insight 6.2.1 – Release Walkthrough & Feature Highlights

Explore the latest innovations in Helical Insight 6.2.1, including massive performance improvements, streaming cache optimization, enhanced canned reporting, advanced dashboard capabilities, improved email integrations, and enterprise-grade BI scalability enhancements.

Introduction

We are excited to announce the General Availability (GA) release of Helical Insight 6.2.1, one of the most powerful open source BI and reporting platforms for enterprises, SaaS applications, embedded analytics, and modern data visualization requirements.

This release introduces major performance enhancements across canned reports, interactive dashboards, chart rendering, and streaming response architecture.
Helical Insight 6.2.1 also delivers new reporting components, advanced visualization capabilities, UI/UX enhancements, enterprise scalability improvements, and stronger security compliance support.

85-90%
Faster Canned Reports

50%
Interactive Dashboard Performance Boost

Enterprise
Scalability & Streaming Architecture

Major Highlights of Helical Insight 6.2.1

A. Performance Improvements & Streaming Cache Optimization

Helical Insight 6.2 introduces a next-generation Streaming Cache Strategy designed to significantly improve report execution speed, memory optimization, and incremental rendering performance.

These enhancements are particularly beneficial for enterprise reporting scenarios involving:

  • Large tabular reports
  • Multi-page canned reports
  • High-volume dashboard rendering
  • Complex data visualization workloads
  • Embedded BI implementations

Key Performance Enhancements

  • Implementation of advanced streaming cache strategy
  • Incremental data loading for faster rendering
  • Reduced memory footprint during report generation
  • Improved handling of massive datasets
  • Better scalability for enterprise reporting workloads
  • Optimized cross-page report viewing performance

B. Email Enhancements

1. Gmail, Microsoft & Zoho Email Support

Helical Insight 6.2 enhances email integration capabilities to support modern email security standards introduced by providers such as Gmail, Microsoft, Outlook, and Zoho.

Users can now seamlessly configure:

  • Email scheduling
  • Automated report delivery
  • Alert-based emailing
  • Enterprise notification workflows


Learn More About Email Configuration →

2. Dropdown-Based Selection for Export Formats

The UI through we select the list of formats while doing emailing/email scheduling has been enhanced. Now it is a drop down, thus allowing better visibility and usage across any device.

Helical Insight 6.2.1 – Release Walkthrough & Feature Highlights

C. HCR (Helical Canned Reporting) Enhancements

1. New Reporting Components

Helical Insight 6.2 introduces powerful new canned reporting components including:

Table
Cross Tab
Bar Charts
Stacked Charts
Grouped Charts
Pie Charts

Helical Insight 6.2.1 – Release Walkthrough & Feature Highlights

2. Abort Functionality in HCR

Similar to our adhoc charts and dashboard designer module, users can now abort long-running report executions directly from the UI. This gives a consistent user experience across all the modules as well as better resource utilization, improved user control and prevent unnecessary server load by disabling long running queries.

Helical Insight 6.2.1 – Release Walkthrough & Feature Highlights

3. Image Component of Canned Report Enhancements:

Dynamic Image Support
  • Direct image URL support
  • Local image upload support
  • Database image path retrieval
  • BLOB image rendering support

Usage of image : Learn More →

Support of ‘Print When Expression’ for Image Component

A new conditional rendering capability has been added for image components using “Print When Expression”. With this, we can display/hide image based on certain condition.

Use case of print when expression on image : View Usage Example →

4. Report level and element-Level Property Configuration

From 6.2 and 6.2.1, both report level and individual element-level property configuration support has been added in canned report. There are hundreds of such kind of properties which exists which can be used to specify the behavior of the application, export controls, data options, formatting options etc. These properties can be applied at the entire application level or can also be individually applied at any component level as well.

You can read about those properties here.

D. Adhoc Report Designer (HReport) Enhancements

1. Custom Formatting Support

Advanced custom formatting support now allows users to define personalized formatting logic for numbers, dates, colors, accounting views, financial reports, and conditional styling.

Examples:

  • Negative values in brackets
  • Green positive values
  • Custom financial formatting
  • Conditional numeric styling

Helical Insight 6.2.1 – Release Walkthrough & Feature Highlights

2. Rename & Order By in Field Context Menu

Users can now rename fields and apply order-by functionality directly from the field context menu. Simply clicking on the dragged fields gives you these options. Earlier in order to rename you can double click on the field and rename. For sorting, there was sorting icon in the dragged fields. Those options are also present as well and can be used.

Helical Insight 6.2.1 – Release Walkthrough & Feature Highlights

3. Tooltip Customization Support

So far, the fields which are part of the rows/columns/marks were only visible in tooltip with no option to control it.

From version 6.2.1, a new “Tooltip” property has been introduced which can allow you to add new fields which can be displayed while the report is being shown. Further whatever fields are being displayed in tooltip can also be controlled, removed, edited as well.

Usage: https://www.helicalinsight.com/tooltip-property-with-configurable-fields/

Helical Insight 6.2.1 – Release Walkthrough & Feature Highlights

Helical Insight 6.2.1 – Release Walkthrough & Feature Highlights

4. Stepped Color Options in Existing Color Property

From version 6.2.1, in the color property, a stepped color option is also added. In case if we are using gradient color, the stepped color option allows to specify the number of color steps between the minimum value color and maximum value color.

Explore Color Configuration → https://www.helicalinsight.com/changing-color-on-a-report-in-helical-insight-5-0/

Helical Insight 6.2.1 – Release Walkthrough & Feature Highlights

5. Percentage Values in Tooltip for Radial Charts

Tooltip support has been enhanced to display percentage values when radial property is enabled.

6. Text Visualization Renamed to Word Cloud

The existing “Text” visualization has been renamed to “Word Cloud” for better usability and clarity and avoid any confusion.

7. Configurable Drillthrough Default Option

Drill through property allows to click somewhere and open a detailed view in the same frame. There were 2 options present i.e. Drill Through & Drill Through Default.

  • Drill Through: Opened child report based on where we have clicked thus showing limited data
  • Drill Through Default: This opened the child report with all data (default values selected while configuring drill through)

In certain cases, to certain users, these 2 options could cause confusion. Hence, from version 6.2 onwards, there is an option to disable Drill Through Default. Hence it will only show Drill Through option only.

Learn More → https://www.helicalinsight.com/configuring-drill-through/

Helical Insight 6.2.1 – Release Walkthrough & Feature Highlights

Helical Insight Platform Security Improvements

Security improvements have been implemented to remove critical vulnerabilities from the Helical Insight application.

Improved Security
Enterprise Compliance
Reduced Risk
Secure Deployment

What’s Coming Next in Helical Insight 7.0

The next major release, Helical Insight 7.0, will introduce powerful AI-driven analytics capabilities including:

  • Conversational Analytics
  • Natural Language Querying
  • Bring Your Own LLM (BYO LLM) Support
  • AI-powered Dashboard Exploration
  • Chat-based Data Analysis

Experience Helical Insight 6.2.1

Helical Insight continues to be one of the leading open source BI tools for embedded analytics, reporting, dashboarding, white-label BI, and enterprise analytics platforms.

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