Dashboards and Reports

Introduction

BPA Application data pushed to elastic search for reporting and dash boards.  We can use this data for search screens or dashboard. Elasticsearch is a distributed, RESTful search and analytics engine capable of solving a growing number of use cases. As the heart of the Elastic Stack, it centrally stores your data and easy to show aggregate reports.

BPA System also providing a default set of reports which are written in Java. Kibana Dashboard is used to show state specific/city specific reports using elastic search.

Prerequisites 

We need to start an elastic search before starting the application server. The elastic search cluster name and port configuration required in wildfly to push data to elastic search.

The folder structure of elastic search related files of BPA module is shown in this picture.

 


Functionality

The indexes are created/update on each action on the application flow. This will help us to generate any kind of report based on the saved data. In case of any correction required in the created index, using scripts, data can be pushed to the Elastic search index. The indexes will be automatically created on the start of the application, for the very first time in the system.


Configurations and Setup

The following three fields are to be updated in egov-erp-override.properties files to enable elastic search. This will be one-time setup.

elasticsearch.hosts=localhost
elasticsearch.port=9300
elasticsearch.cluster.name=egovelasticsearch

Support Information

The latest version of kibana supports to combine multiple index to generate report. Please refer below link for more information,

https://www.elastic.co/guide/en/kibana/current/dashboard.html

Dashboard URL

https://kzkibana.egovernments.org/app/kibana#/dashboard/DIGIT-DCR-and-LBE-Dashboard?_g=(refreshInterval:(display:Off,pause:!f,value:0),time:(from:now-15m,mode:quick,to:now))&_a=(filters:!(),options:(darkTheme:!t),panels:!((col:4,id:Service-wise-Plan-Scrutiny-Count,panelIndex:2,row:1,size_x:3,size_y:3,type:visualization),(col:1,id:Total-Number-of-Plan-Scrutinized,panelIndex:3,row:1,size_x:3,size_y:3,type:visualization),(col:1,id:DIGIT-DCR-Occupancy-wise-Status,panelIndex:5,row:11,size_x:12,size_y:5,type:visualization),(col:10,id:Stakeholders-Registration-Status,panelIndex:6,row:1,size_x:3,size_y:3,type:visualization),(col:7,id:Total-Number-of-LBE-Applied,panelIndex:7,row:1,size_x:3,size_y:3,type:visualization),(col:7,id:Type-of-LBE-Registered-and-Approved,panelIndex:8,row:4,size_x:6,size_y:3,type:visualization),(col:1,id:DIGIT-DCR-Plan-Scrutiny-DailyStatus,panelIndex:12,row:7,size_x:12,size_y:4,type:visualization),(col:1,id:DIGIT-DCR-Plan-Scrutiny-Weekly-Status,panelIndex:13,row:4,size_x:6,size_y:3,type:visualization)),query:(query_string:(analyze_wildcard:!t,query:'*')),title:'DIGIT%20DCR%20and%20LBE%20Dashboard',uiState:(P-12:(spy:(mode:(fill:!f,name:!n)),vis:(legendOpen:!f)),P-13:(vis:(legendOpen:!f)),P-2:(vis:(legendOpen:!f)),P-6:(vis:(colors:(APPROVED:%237EB26D,BLOCKED:%23E24D42,REJECTED:%2364B0C8,SUBMITTED:%23F9934E,UNBLOCKED:%23EAB839),legendOpen:!f))))



References and Notes