Problem Statement: The client required the ability for the end users to import pre-created and pre-categorized dashboards, inside their own custom created category, for the said dashboards.

Problem Description: The client wanted to provide the end users with a set of dashboards that were created beforehand, as templates, that could be used by the client to visualize his data. The client also wanted to give the end user the ability to re-categorize the dashboards and make any changes they see fit. Thus every end user can have their own folder structure with dashboards present inside it.

File Structure

Solution Designed: For the above stated problem, Helical Workflow (HWF) was used to provide the solution –

  1. Share the templates with the end users. i.e- The end users can view the templates but not edit.
  2. On selection of the desired templates, copy them to the client and give him the creator permission (i.e- Make the client admin the creator of the copied dashboards) and share them with the all users of that organization, with edit permissions. Thus, making the dashboards editable for all users of the clients organization.
  3. While copying, the characterization can be redefined by the client as per his needs.

 

Solution Feasibility: The desired functionality was not an out-of-the-box feature of Helical Insight (HI). However, HI provides the ability to create any desired functionality and add it to the application as an add-on.

            This is achieved by making use of the HWF module of HI. HWF stands for “Helical Work Flow”, which allows the user to define a workflow of his desired functionality. Using Helical Workflow, customers can implement their own custom business processes, call any functional modules of BI (like folders, email scheduling, exporting, caching etc) whenever they want. Also customer can custom code their own functional module and integrate using workflow.

            HWF allows the user to add Java Code of the said functionality into Helical Insight without having to open the Helical Insight core files. HWF has access to all the API provided by HI and the user can use them directly, as if adding the feature into the core application itself.

            The HWF acts as a mount point for any functionality that needs to be added as a custom feature, making HI highly adaptable and customizable.

Solution Application:

  1. The first step was to create a UI for selecting the dashboard.

For this, an option was created in the menu-dropdown list which would redirect the user to the dashboard selection page.

  1. Dashboard Selection page:

The Dashboard selection page contains the list of available templates which can be selected and an input box to put the category in which the dashboard must be put.

The input box can accept a category hierarchy so that the user can put dashboards into sub categories.

  1. When the user is done with selecting the dashboards and defining the category hierarchy, he can finalize his selection by submitting it.
  2. The submit button will, in turn, trigger the HWF file containing the java code to import the dashboards.

The HWF file will return a response with success or failure of the import process, which will be used to display the relevant message on the screen.

HWF Flow diagram

Menu :

menu

Dashboard Selector :

BI Workflow, Helical work flow

This view will appear on clicking “Dashboard Selector” option from the menu list.

  1. Category Name : Define user specific category for saving dashboard
  2. Search : For Searching dashboard
  3. Shows the list of dashboards available

In the dashboard selection user can define category name, can select one or more dashboards from the dashboard list. On clicking “Add Dashboard” these dashboards will be saved inside the folder whereas folder name will be defined as Category Name. This is achieved using Helical Workflow (HWF).

To know more mail us at support@helicalinsight.com

or

Post your queries on forum : forum.helicalinsight.com

Leave a Reply

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