Cyclic Cascading of Parameters in Helical Insight

In this blog, we will discuss about how we can implement cyclic (One to Many) cascading between multiple parameters in Helical Insight. In this blog we have covered how to do it in the versions upto version 4.1. This kind of filter is called as interactive filtering in PowerBI. This allows the value of one filter to respond to other filters, the other filter can also respond to first filter.

Pre-requisite :

– Helical Insight application version 4

– Knowledge of how basic cascading filtering works in Helical Insight version 4. For understanding the same you can refer our detailed documents:

  1. https://www.helicalinsight.com/creating-cascading-parameter-helical-insight/
  2. https://www.helicalinsight.com/implement-cascading-input-parameters-helical-insight/

Follow below steps to implement cyclic cascading between parameters:

  1. Create adhoc report in your Helical Insight application with filters / parameters which you want to apply. For reference, we have created sample tabular report with multiple columns and 3 different filters / parameters.

    Visualization More Charts

  1. Create a file with extension efwd and store this file into any folder of your hi-repository. In this file we need to provide SQLs of our input parameters. For reference, in our example we have created 3 input parameters destination, source and employee_name. SQLs for listing this parameters will be part of efwd file. Below we have taken 1 reference of employee_name parameter SQL :
<DataMap id="1" connection="1" type="sql" >
                                <Name>Query for EmployeeName</Name>
                                <Query>
                                                <![CDATA[
 
select 
                                                                "HIUSER"."employee_details"."employee_name" as "employee_name" 
                                                from
                                                                "HIUSER"."travel_details" 
                                                                inner join "HIUSER"."employee_details" on ("HIUSER"."employee_details"."employee_id" = "HIUSER"."travel_details"."travelled_by") 
                                                where
                                                                (("HIUSER"."travel_details"."destination" in (${destination}) OR ('_all_') in (${destination})) AND ("HIUSER"."travel_details"."source" in (${source}) OR ('_all_') in (${source})))
                                                group by
                                                                "HIUSER"."employee_details"."employee_name"
                                                ]]>
                                </Query>
                                <Parameters>
                                                <Parameter name="source" type="Collection" default="'_all_'"/>
                                                <Parameter name="destination" type="Collection" default="'_all_'"/>
        </Parameters>
                                </DataMap>

Above mentioned SQL is for listing employee_name. Within this SQL we have passed other 2 parameters of source and destination in the where clause. This we have done in order to achieve cascading. Once any value gets changed in source and destination filters, then those values will be passed as filter to this employee_name sql and accordingly the list will be generated.

Same thing we are going to do for other 2 parameters of source and destination as well.

– In listing SQL of source -> we are going to pass employee_name and destination as filter.
– In listing SQL of destination -> we are going to pass employee_name and source as filter.

  1. Once we have created efwd file with all parameter SQLs then we can start creating our Dashboard. In order to create dashboard from HI version 4 open Dashboard Designer, create select OR select 2 kind of parameter from front end UI of dashboard designer.

While creating any parameter make sure that you are setting variable of that parameter as well as listening to our input parameters and taking those values in input section.

For example : We are taking reference of employee_name input parameter. This parameter will set value of employee_name variable but it will listen to source and destination parameters and takes the values of source and destination as input. Refer screenshot below :

Cyclic cascading Of Parameters In Helical Insight

Cyclic cascading Of Parameters In Helical Insight

Similarly create other 2 parameter of source and destination.

For source -> It will set variable of source and listen to employee_name and destination as well take values as input of employee_name and destination.

For destination -> It will set variable of destination and listen to employee_name and source as well take values as input of employee_name and source.

This way it will become cyclic cascading where every input parameter will change other parameters and the same parameter will get change on changing of other parameters.

Cyclic cascading Of Parameters In Helical Insight

You May Also Like

Helical Insight’s self-service capabilities is one to reckon with. It allows you to simply drag and drop columns, add filters, apply aggregate functions if required, and create reports and dashboards on the fly. For advanced users, the self-service component has ability to add javascript, HTML, HTML5, CSS, CSS3 and AJAX. These customizations allow you to create dynamic reports and dashboards. You can also add new charts inside the self-service component, add new kind of aggregate functions and customize it using our APIs.
Helical Insight’s self-service capabilities is one to reckon with. It allows you to simply drag and drop columns, add filters, apply aggregate functions if required, and create reports and dashboards on the fly. For advanced users, the self-service component has ability to add javascript, HTML, HTML5, CSS, CSS3 and AJAX. These customizations allow you to create dynamic reports and dashboards. You can also add new charts inside the self-service component, add new kind of aggregate functions and customize it using our APIs.
Helical Insight, via simple browser based interface of Canned Reporting module, also allows to create pixel perfect printer friendly document kind of reports also like Invoice, P&L Statement, Balance sheet etc.
Helical Insight, via simple browser based interface of Canned Reporting module, also allows to create pixel perfect printer friendly document kind of reports also like Invoice, P&L Statement, Balance sheet etc.
If you have a product, built on any platform like Dot Net or Java or PHP or Ruby, you can easily embed Helical Insight within it using iFrames or webservices, for quick value add through instant visualization of data.
If you have a product, built on any platform like Dot Net or Java or PHP or Ruby, you can easily embed Helical Insight within it using iFrames or webservices, for quick value add through instant visualization of data.
Being a 100% browser-based BI tool, you can connect with your database and analyse across any location and device. There is no need to download or install heavy memory-consuming developer tools – All you need is a Browser application! We are battle-tested on most of the commonly used browsers.
Being a 100% browser-based BI tool, you can connect with your database and analyse across any location and device. There is no need to download or install heavy memory-consuming developer tools – All you need is a Browser application! We are battle-tested on most of the commonly used browsers.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
A first-of-its-kind Open-Source BI framework, Helical Insight is completely API-driven. This allows you to add functionalities, including but not limited to adding a new exporting type, new datasource type, core functionality expansion, new charting in adhoc etc., at any place whenever you wish, using your own in-house developers.
A first-of-its-kind Open-Source BI framework, Helical Insight is completely API-driven. This allows you to add functionalities, including but not limited to adding a new exporting type, new datasource type, core functionality expansion, new charting in adhoc etc., at any place whenever you wish, using your own in-house developers.
It handles huge volumes of data effectively. Caching, Pagination, Load-Balancing and In-Memory not only provides you with amazing experience, but also and does not burden the database server more than required. Further effective use of computing power gives best performance and complex calculations even on the big data even with smaller machines for your personal use. Filtering, Sorting, Cube Analysis, Inter Panel Communication on the dashboards all at lightning speed. Thereby, making best open-source Business Intelligence solution in the market.
It handles huge volumes of data effectively. Caching, Pagination, Load-Balancing and In-Memory not only provides you with amazing experience, but also and does not burden the database server more than required. Further effective use of computing power gives best performance and complex calculations even on the big data even with smaller machines for your personal use. Filtering, Sorting, Cube Analysis, Inter Panel Communication on the dashboards all at lightning speed. Thereby, making best open-source Business Intelligence solution in the market.
With advance NLP algorithm, business users simply ask questions like, “show me sales of last quarter”, “average monthly sales of my products”. Let the application give the power to users without knowledge of query language or underlying data architecture
With advance NLP algorithm, business users simply ask questions like, “show me sales of last quarter”, “average monthly sales of my products”. Let the application give the power to users without knowledge of query language or underlying data architecture
Our application is compatible with almost all databases, be it RDBMS, or columnar database, or even flat files like spreadsheets or csv files. You can even connect to your own custom database via JDBC connection. Further, our database connection can be switched dynamically based on logged in users or its organization or other parameters. So, all your clients can use the same reports and dashboards without worrying about any data security breech.
Our application is compatible with almost all databases, be it RDBMS, or columnar database, or even flat files like spreadsheets or csv files. You can even connect to your own custom database via JDBC connection. Further, our database connection can be switched dynamically based on logged in users or its organization or other parameters. So, all your clients can use the same reports and dashboards without worrying about any data security breech.
Our application can be installed on an in-house server where you have full control of your data and its security. Or on cloud where it is accessible to larger audience without overheads and maintenance of the servers. One solution that works for all.
Our application can be installed on an in-house server where you have full control of your data and its security. Or on cloud where it is accessible to larger audience without overheads and maintenance of the servers. One solution that works for all.
Different companies have different business processes that the existing BI tools do not encompass. Helical Insight permits you to design your own workflows and specify what functional module of BI gets triggered
Different companies have different business processes that the existing BI tools do not encompass. Helical Insight permits you to design your own workflows and specify what functional module of BI gets triggered