In this blog, we will see the various security levels available for querying tables using custom columns or custom filter values in Helical Insight adhoc reports module. Helical Insight has various placeholders where you can use SQL queries. At the metadata level there is option of writing SQLQuery and saving as a view.At the adhoc
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
As Helical Insight supports Multi-tenancy, users would like to see data which is relevant to them. For example, Sales managers would like to see the reports/dashboards of sales data, Finance managers would see only financial reports etc. For that, ‘Metadata security’ feature can be used in which user can grant or deny the permission of
Read More
This article talks about the expressions which can be used while writing data security conditions at the metadata level of Helical Insight BI application. Expressions are the statement used for writing conditionIf and groovy code. Operators : User Based Expressions : Role Based Expressions : Profile Based Expressions : Organization Based Expressions : For Queries,
Read More