We are releasing Open Source BI product Helical Insight version 5.2 (5.2.0.1473 GA) in May 2024. In this blog we are going to talk about what all are the new features which have been added as compared to version 5.1 (i) New Database support: With every new version of Helical Insight, we continue to add
Read More
In previous blog, we have learned about how to use Date filter in Open Source BI Helical Insight application version 5 with different options like In Between, in Range, Equals, Greater Than, Less Than, Greater Than Equal to, Less Than Equal to etc. Helical Insight allows to pass filter name and filter values also directly
Read More
This feature is newly introduced from version 5.2 (5.2.0.1473 GA) in Open Source Business Intelligence product Helical Insight. This functionality of cut/paste and copy/paste can be useful to migrate from one folder to another folder within the same file browser of Helical Insight. Usage : From the home page, click on File Browser. Now right-click
Read More
Visualization Framework (VF), is a framework that is used to generate different visualizations. The VF accepts JavaScripts to generate the required visualization. The Reports module provides some predefined visualizations and also allows users to add newer, often required visualizations to that list. However, if the user requires to use a certain visualization for an exceptional
Read More
In this blog we will cover how to export a reports data in Excel or CSV format in a dashboard for version 5.0 onwards of Open Source BI product Helical Insight. NOTE: This will export individual panel data of a dashboard. It is not possible to export entire dashboard data into a single CSV/Excel, reason
Read More
If a CrossTab has more than one row/column group level, then this functionality give control to the user to specify whether or not to enable the CrossTab to be expanded at runtime, and set the default expanding/collapsing state of groups in the outer level. This functionality is available in CrossTab property and which is applicable
Read More
This article shows how to apply page break in group footer which is used to display totals at the group level. A Page Break or hard page break is a code inserted by a software program (e.g., word processor) telling the printer where to end the current page and begin the next. To add a
Read More
In this blog we are going to cover how to connect CSV files in Helical Insight 5.1 via apache drill It will also support flat files like excel ,json , parquet files etc ( process will be same as CSV) Follow below steps : 1. Download, install and start Apache Drill. To learn how to
Read More
In this article we will see how we can create a dynamic parameter for canned reports.This document has been created for Helical Insight version 4.1 GA. A parameter is a variable that takes the value passed by the user and hence the data gets filtered before it is displayed on your screen. A parameter can
Read More
This article shows various types of settings for listeners of parameters added in the canned report. This blog has been created for Helical Insight version 4.1 GA canned reporting module. Briefly, the steps involved in creating a canned report are: Create a connection Write a query without where clause Add input parameter and give its
Read More