In this blog, we will show you how to connect to open source analytics engine, ElasticSearch to Open Source BI product Helical Insight. Follow the below given steps in order to connect Helical Insight to ElasticSearch: Step 1: Download this zip file and extract the contents. Step 2: Go to DataSources page and click on
Read More
Introduction: In this blog we are going to explain how to implement data security based on the logged-in user name. We have created sample tabular report having the data of client wise meeting date. In this example covered in the blog, we want to filter the data based on the user name of the user who
Read More
Introduction:In this blog we are going to explain how to implement data security based on the logged-in organization. We have created sample tabular report having the data of client wise meeting date. In this example covered below, we want to filter the data based on the organization that the user belongs to. Organization for default
Read More
In this blog we shall see how to create canned reports with ALL as default value in input parameters. STEP 1: Create a connection To know more about the types of datasource connections that can be established, refer to the blog. STEP 2: Write a query without using parameter/where clause After providing the connection details
Read More
In this blog we shall see how to create canned reports with multi select input parameters. STEP 1: Create a connection To know more about the types of datasource connections that can be established, refer to the blog. STEP 2: Write a query without using parameter/where clause After providing the connection details in the previous
Read More
Canned reporting interface provides one more method of implementing multiselect parameter and that is using checkbox. In this blog we are going to cover how to implement the same. Below is a snapshot of how the checkbox input parameter looks like STEP 1: Create a connection To know more about the types of datasource connections
Read More
In this blog we will see how to create a canned report with a date picker as input parameter. We will give an end user an option to select the date, and all the data greater than that specific date will be available in the report. STEP 1: Create a connection To know more about
Read More
In this blog we shall see how to create canned reports with input parameters with single select. STEP 1: Create a connection To know more about the types of datasource connections that can be established, refer to the blog. STEP 2: Write a query without using parameter/where clause After providing the connection details in the
Read More
In this blog we will see how to create a canned report with a date range selector as input parameter. STEP 1: Create a connection To know more about the types of datasource connections that can be established, refer to the blog. STEP 2: Write a query without using parameter/where clause After providing the connection
Read More
In this blog, we are going to see how to connect to the Datasources page in the canned reports module and other features present on the page. In order to go to the datasources page, click on the Datasources button on the left hand side of the canvas or on New Datasource in the datasource
Read More