End2End (e2e) Enquiry Engine - Philosophy

You have corporate or departmental applications using formal databases or a structured spreadsheet mechanism, but reporting on these data is complex and time consuming. HS&H's end2endSystems provides a flexible, user-driven platform to meet your data browsing and extraction requirements.

  • Enquire on your live application data
  • Enquire on snapshot views
  • Pre-designed browsing
  • Ad hoc designer
  • Excel/XML output
  • Drilldown browsing from summary to details
  • Enrich data by adding datestamped notes to browsed results
  • Share your designs with others
Fig.1: The e2e System Concept

Our e2e Solution

The e2e environment facilitates the extraction and display of your application data that is currently ‘locked in’ within your databases. Our solution does not affect your application or databases, but sits alongside benignly enabling you to make and execute enquiries to extract your requested data. The e2e database holds templates of your browsing – or extraction – requirements against the various enquiry designs you want to make. For each design, we supply a set of components you use to build your collection of underlying enquiries. Any enquiry can itself be used to derive further enquiries.

Enquiries can be made private for your own local and confidential consumption, or shared across your user group.

The e2e environment is not limited to serving a single database; it can be used to report on any number of back-ends, either singly (as separate reporting applications) or together for consolidation and reconciliation functions.


Arrangement 1Arrangement 2Arrangement 3Arrangement 4Back to top


Arrangement 1: Shortfall in Application Reporting

There are few or no reporting capability from your established applications. Plenty of data capture and processing, but user- and customer-centric output is limited. Your users have diverse requirements leading to fragmented ‘downstream’ solutions using the likes of MS Excel or MS Access, which are difficult to control and manage as the company and requirements grow.

Fig. 2a: Application Reporting Shortfall Arrangement

Solution

e2e knows how your data are stored for direct querying.

Fig. 2b: Application Reporting Shortfall

Output from the e2e environment can be in the form of:


Arrangement 1Arrangement 2Arrangement 3Arrangement 4Back to top


Arrangement 2: Data Consolidation or Summaries Required

A local database is constructed to store consolidated and summarised calculations which are not available within your application database. The e2e environment has complete knowledge of this new data source and uses it as a second data source (emulating Arrangement 1). Direct enquiries from your own database are still available, of course.

Fig. 3: Data Consolidation or Summaries Arrangement

Arrangement 1Arrangement 2Arrangement 3Arrangement 4Back to top


Arrangement 3: No Application Database

You receive data on demand into say, an Excel spreadsheet, from an external third party or applications which have no other means of distributing data. Within these workbooks, you construct your own datasets, but there is no formal ‘contract’ from the downloading agent.

Fig. 4: No Application Database

A local database is constructed to receive the external data and store in a formal arrangement. The e2e environment has complete knowledge of this new, derived data source and uses it as your application’s data source.


Arrangement 1Arrangement 2Arrangement 3Arrangement 4Back to top


Arrangement 4: The Mixed Mode for Diverse Application Data

Your current applications supply low level local data, but you require summarised (cubed) or merged data, e.g. inter system reconciliation and summaries, overnight batching etc.

Fig. 5: Mixed Mode Arrangement

Arrangement 1Arrangement 2Arrangement 3Arrangement 4Back to top