 |
 |
 |
 |
 |
SOLUTIONS |

Overview
An Agriculture based product company had a legacy system that specialized in management information systems
This legacy system, had a number of inadequacies including gaps in functionality that would allow the customers/end users give a free hand in generating reports on ad-hoc basis. Further, for generating newer reports which is not pre-configured in the system, there were lot of dependency on Support team and in certain cases it was leading to poor response times.
Sryas stepped in here to provide a reporting module solution using latest technologies with acesss to the legacy system there by letting the users/existing customers to continue use the existing TWS Agri Software. This gave the client the option of migrating to modern technologies without losing the benefit of already existing mature solutions.
Enterprise Reporting Tool
Enterprise Web reporting tools like Visual Reporting Tool allows companies and organizations to gain a better understanding of all of their business by putting critical information in the hands of all those who need it – employees, managers, partners, and customers.
Interactive Web Reporting
- Ad-hoc querying and generating static and dynamic reports
- The tool provides an intuitive, graphical interface that shields users from technical complexities and allows them to use business terminology instead of database terminology
- lets these users have the flexibility to modify and save report views
- Craft ad hoc web reports by using pre-defined templates reports
- Novice users running structured ad hoc reports and performing general reporting queries can quickly and efficiently satisfy their own information needs in real time
Spreadsheet Reporting
- Creates multi-range, three-dimensional workbooks with pivot tables
- Automatically replicated formulas, dynamic matrix tables, embedded VB macros, data filters and live charts
- Reduces design oriented errors and allows organizations to eliminate the time users would spend building their own spreadsheets by supplying them directly
- Generates data driven spreadsheets
- Users enjoy fully functional workbooks that can expand along three axes - rows, columns and worksheets. Worksheets can contain charts and graphs, data filters, pivot tables, and Excel formulas
- Workbooks can also contain Visual Basic macros, while tables and cells can support conditional formatting and locking
- The tool tailors each workbook for each user, without re-querying all the original sources or re-executing the original design. It dynamically assembles the workbook as the user requests it, which allows it to combine both cached and real time data, at that moment
- Architecture not only provides a high degree of personalization, it also scales to thousands inside and outside the firewall
Business Analytics
- Includes an easy to use query editor to retrieve information from relational data sources
- The editor includes drag and drop table and column manipulation, parameterization, direct SQL access and data preview capabilities
- Delivers rich, robust OLAP capabilities - slice and dice, filter, sort, hide, calculations, drill to details and more
- Empowers advanced users with hundreds of options to pivot, filter, resort, and recalculate items so they can better manipulate and analyze information
- End users can drag, drop and pivot a cube's dimensions and measures within a tabular or graphical view
- They can expand, collapse and navigate hierarchies, create custom calculations, sort, filter and hide columns, and add conditional highlighting to cells
- Capabilities to add custom header and footer color, create custom croup headers and footers
- Grouping functionalities like group by Year, Quarter and Month. Grouping by financial quarters (Q1/Q2/Q3/Q4)
- Support for different date formats
- Capability to create multiple level groups with totaling, sub totaling including functionalities for adding custom formulas and runtime columns
- End users can work in varied presentation formats, online or offline, export to Excel, Word, PDF etc.
Dashboards
- The tool can access data from any combination of historical, ERP, legacy or live systems and integrate that data into a unified view
- Easy tailoring of the environment's look-and-feel from prepackaged templates; customization with background colors, wallpaper, links, and company logos
- Customizable portals that enable users to personalize their environment by selecting the way they view, store, and retrieve information
- The ability to navigate and pinpoint the exact reports needed from a drop-down menu or expanding tree; the list can include both public and private reports viewable by a specific user or group of users
- Automated report distribution allows users to schedule reports distribution
- Pull up and display archived reports from the report library
|

|
|
 |
 |
 |

|
 |

|