In this blog we will cover how to show a report in dashboard only when a value in the filter is selected in the open source BI product Helical Insight. Otherwise the chart should be in invisible mode and not visible. When filter value is selected then only the chart should render. Go to the
Read More
In this blog we are covering the best practices which should be followed while using Helical Insight to create your reports, dashboards, embedding, Single Sign On, optimal performance, higher security etc. DATASOURCES: a) Dynamic DB Switching : – There are certain cases when we would like the report or dashboard to all together switch to
Read More
NOTE: From version 5.2.2 of Open Source BI Helical Insight, we have provided DIRECT inbuilt support to Excel as a datasource. This method is much more simpler to use and recommended. Please refer to this link to learn more: https://www.helicalinsight.com/usage-of-flat-files-excel-in-helical-insight/ If you are using older version or want to use Apache drill, then continue to
Read More
In this specific blog we would be covering db specific functions which are specific to NoSQL databases like Mongo etc present in the version of Helical Insight 4.1. Some of these functions like handling of JSON are now also are present for newer versions of databases like Postgress, MySQL etc JSON Specific function 1) You
Read More
With version 4.1 GA of Helical Insight we are also supporting JWT as well. JWT offers a lot of advantages like enhanced security, sessionless mode support when implementing load balancing server at Helical Insight, another method of SSO implementation and more. In a stateful architecture, when the load or session is shifted to another server,
Read More
May’2021: If you are still using Oracle Reports, you will soon need to find an alternative for your reporting needs as the current oracle reports are reaching end of life cycle. Open Source BI product Helical Insight is an excellent tool that can replace Oracle Reports and offer you much more. For starters, Helical Insight
Read More
May’2021: If you are still using BIRT Reports, you will soon need to find an alternative for your reporting needs as the current BIRT reports are reaching end of life cycle. Open Source BI product Helical Insight is an excellent tool that can replace BIRT Reports and offer you much more. For starters, Helical Insight
Read More
In this blog, we shall show how to convert a scatter chart into a bubble chart in Helical Insight. There are various customization scripts available for different visualizations in Helical Insight. We have created a customization to adjust the bubble size based on the measure selected. You can download this customization script: BubbleSizeCustomization.script 1 Place this script
Read More
Enh : Enhancement Req : Requirement (new feature) HELICAL INSIGHT 4.1.1.18666 GA release: Login: #Enh: Maintain stateless session using JWT Datasource: #Req: Migration of globalConnection.xml from file based to DB #Req: Supporting datasource conncurrency [tested with 1500 connections] #Req: Improved datasource performance [tested with 1500 connections] Metadata: #Req: Implemented pagination in metadata module resulting in
Read More
In this blog, we shall see how to add the back button in a report. If you have implemented drill down in the mode “Open in Same Tab/current tab” then in the child report you will have to add a back button. Clicking on the back button will open the parent report once again. For
Read More