Canned Reporting in Helical Insight 6.0: Pixel-perfect reports, flexible deployment, SSO, embedding, and multi-format export for modern BI needs.
Read More
In our last post we discussed the need of BI tools. Click here to read about it. In this post let us explore the features that we should consider while purchasing a BI product. We shall further explore what makes each BI product stand out. Before opening the pandora’s box with the tools which are
Read More
The definition of Business Intelligence (BI) can be quite complex, but in general, it is a process of transforming raw data into meaningful and insightful information that can help businesses make better decisions.
Read More
Sometimes, you may want to modify the query generated for a report based on the input parameters selected by end user. Different filter values may trigger different queries in such cases. To achieve this easily, dynamic query view feature has been added at metadata level in Helical Insight. What is dynamic query? Dynamic query essentially
Read More
This blog gives details about the filter expressions that can be used in the dynamic query view on the metadata page of Helical Insight. Dynamic queries allow the report level filters to be used in the view to generate the query based on those filters. Filters can be accessed by using the ${filter} notation. Filter
Read More
Introduction: In this blog we are going to explain how to use checkbox in multi select parameters in Community Edition Reports. Here we are creating a sample report which shows travel medium wise cost. Please make sure you have gone through the blog “Introduction to Community Reporting Interface.” Steps to create pie chart using filter
Read More
Introduction : There might be certain reports/dashboards wherein we would also need “ALL” as one of the input values, so when ALL is selected the entire data will be shown and then further use can further select any specific value. This ALL can be preset in both single select and multiple select input parameters. In
Read More
In this blog, we shall see how to create a stacked bar chart in Helical Insight. To create stacked bar charts, the first dimension (shown on the axis) will be the first column. Each data item to be shown in the stack should be shown in separate columns. Hence in certain cases you might have
Read More
Introduction: In many cases we would like to display the filters values which have been selected at a specific place. So in this blog we would describe how that can be done. Concept: Via dashboard.getVariables(NameOfFilterVariable) we can get the values of the selected filters. Fo what we can do is we can create some HTML
Read More
Apply database functions to fields in an Adhoc report to transform, format, extract or manipulate text, numeric, date and date-time values. For example, you can convert a date to its year, change text to uppercase, or round a number to a set number of decimal places. The functions available depend on the database you are
Read More
