business intelligence Archives

Dynamic Query View in Metadata

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

business intelligence, open source, open source BI

Share with

Filter Expressions for Dynamic Query View

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

business intelligence

Share with

Checkbox usage in Community Edition Reports

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

BI tool, business intelligence, checkbox, helical insight, open source

Share with

Setting ‘ALL’ as the Default Input Parameter Value in Community Reports

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

BI tool, business intelligence, community reporting, open source

Share with

Creating a Stacked Bar Chart in Helical Insight

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

business intelligence, charts, helical insight, open source, stacked bar chart