Anoman - A custom report frame work to fetch & analysis of linear data in a customizable way
By Raja Renga Bashyam from Coimbatore.pm
Date: Saturday, 3 December 2016 17:15
Duration: 20 minutes
Target audience: Any
Language: English
Tags: customreport qualitativeanalysis quantitativeanalysis reportbuilder reporting sqlbuilder
You can find more information on the speaker's site:
Anoman report frame work virtually builds a SQL SELECT query based on user inputs. It contains SELECT fields, WHERE filters by using IN, Regular Expression matches, value ranges, GROUP BY columns and ORDER BY fields.
Anoman conceptualized and continually evolved by customer requirements and use cases. In one of our software implementation, we have a task to implement almost 70 pre-defined reports on one table. A team of few, we don’t have much hands to develop it. Our organization principles are highly influenced by Lean Methods & TQM. In that direction we thought to have one interface, where the user can fetch the data as the way they need. We highly looked the possibility of reuse in future needs to attain long time benefit.
The custom report implemented with the options to select information fields, filters, group values, date filters; order by fields by the user as the way it’s needed. Anoman has given an unlimited freedom for the user to pick & analysis the data in different dimensions. The system incrementally improved with new features in each installation. Features like, bookmark the report selection, aggregate results, graphical display, etc added in further versions.
The report configuration implemented in Perl HoH structure. It’s helped to implement the system with semi skilled resources through SOP. Hash based configuration came handy in transforming real time tweaks with ease. The user selection finally transformed to a SQL query like
SELECT a,b,c FROM d WHERE e IN (1,2) AND f=’g’ AND h BETWEEN i AND j GROUP BY k ORDER BY l,m
Anoman implemented in different domains like project management, whole sale trading and few other information systems in a short span. The system highly coupled with our legacy internal environment that implemented in CGI::Ajax. After some stage, we faced difficulty in integrating with other PHP based applications. Now we are re-building it as an independent system, where it can be integrated with other systems smoothly. Also we planned to make it open.
In this talk, I will share the tools inner components, existing use case and a short hands-on implementation.
Attended by: Jody Belka (knewt),
