In this blog, we introduce Open Source BI Helical Insight as a compelling alternative to SAP BI reporting. Helical Insight offers a cost affective robust platform for data analysis and reporting, empowering businesses with customizable dashboards, interactive visualizations, and advanced analytics capabilities. Discover how Helical Insight revolutionizes BI reporting, providing flexibility, scalability, and actionable insights for informed decision-making. Helical Insight: Adding extensive BI capabilities to SAP Platform Helical Insight stands out as a beacons of innovation in the realm of SAP ..read more

Map visualization enables users to analyze and understand spatial data in visual format.Map in Helical Insight tool allows user to represent geographic data, by plotting data points on maps which might remain hidden in tabular data. Prerequisites to work with Map visualization in HI version 5.1.0 : 1. To generate map visualization we need GeoJSON data of countries,states and cities ,etc. 2. To create map report user needs to add dimension field in column/row shelve which is having geographical data in it.Also we can use co-ordinate fields (Latitude and Longitude) to create map visualization. N ..read more

In the ever-evolving landscape of data analytics and visualization, the power of open source tools has become increasingly evident. Among the plethora of options available, Helical Insight emerges as a beacon of innovation and reliability, spearheading a revolution in data visualization. Let’s delve into why Helical Insight stands tall as the frontrunner in the realm of open source visualization tools. Unmatched Customizability Helical Insight offers unparalleled flexibility, allowing users to tailor their visualizations to suit their precise needs. With its modular architecture and extensive ..read more

In helicalinsight few values are restricted in filter expression for the security reasons. If you pass that restricted keyword you might get the below error Error: HCRException: The filter value is unaccepted, please try with someother value. In case if you compulsory want those values to be passed in filter expression then navigate yourself to this location /HelicalInsight/hi/hi-repository/System/Admin Here you will find ‘defaults.properties’ file you will find the below keywords CREATE|DELETE|DROP|INSERT( +INTO){0,1}|MERGE|SELECT|UPDATE|UNION( +ALL){0,1}|FROM|WHERE|SLEEP try to remove ..read more

In case if you are looking for support and usage of Helical Insight with Time Plus proton you can follow the steps mentioned in the below document to learn how to do the same. In our subsequent versions Helical Insight will already have all the required files and configurations will be by default present as part of the Helical Insight package itself. Download the TimePlus_Proton.zip and extract Copy timeplus.xml and timeplus.js file into below server path “...\hi\hi-repository\System\Admin\SqlFunctions" Open sqlDialects.properties file present at the location “….\hi\hi-repository\System\Adm ..read more

After release Helical Insight 4.1 GA, there were many more functionalities which were expected by end customers on the canned reporting module for which custom patches were deployed. In this blog we are going to cover about those custom patches and using them as well as what does that custom patch do. 1. Excel continuously This patch will help to print the excel data continuously. Right now even in excel the data comes in a paginated format (the way it appears in PDF) but this patch will help in exporting the canned report in such a way that it appears in a continuous format. 2. Managed to gro ..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 Page break follow the below steps. First add a parameter named ‘pagebreak’ on datasource page and choose the connection for it. Then on canvas, add a textbox with width=pagewidth and height=2 units, at the group footer where you want to introduce page break and give it a name that can be easily located in .h ..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 install Drill please follow below blog https://www.helicalinsight.com/drill-installation-helical-insight/ 2. Once it is up you can access the Apache drill UI at https://:8047 3. Go to storage and click on update of dfs. We should make the following changes in the configuration. Inside root > provide your locatio ..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 be static or dynamic. Static parameters are those that are created using the columns present in Select statement of the query. For example, in our sample database we can select “Travel_medium” as one parameter and all the values will be then populated under “Travel_medium” parameter from the d ..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 proper configuration After adding parameter with correct configuration, we have to specify that this report should listen to that specific input parameter. For this Click on P icon. You will then see the added parameter list. For example, this screenshot shows ..read more