Essentials Framework


The Essentials Framework is series of complimentary modules…each building on the other towards these ends:

  1. – Making data from Notes applications ubiquitously available.
  2. – Empowering organizations to easily transform data into actionable Business Intelligence.
  3. – Removing barriers to transform traditional pain points of thin client development and deployment.
  4. Enabling reusable reports that can be run by anyone in the organization. 

The Essentials Framework resides in a single Lotus Notes application weighing in at a mere 3MB.  In all respects it is a normal Notes database, which means it can be located, secured, backed-up, replicated, etc., as you would any other database in your Notes environment

There are no plug-ins for the end user to install.  There are no DLLs or other libraries required at the server level.  All that is required is a Lotus Domino server with the http task running and an appropriate ID i.e. admin rights.

Essential Data

The Challenge: 

– Getting a snapshot of data on all current issues in the environment
– Getting a snapshot of data from six months or one year ago
– Extracting data in a universal form that can be used and reused anywhere

 

Essential Data can overcome each of these challenges all by creating a simple Data Profile. Essential Data allows you to take any collection of Notes documents, from any database, and turn them into well-formatted, targeted XML/JSON.

Essential Data uses easily-configured Notes documents called Data Profiles to describe WHERE, and HOW to get the data, as well as the FORMAT of the output data.  Each Data Profile has a restful URL, which when called produces the appropriate data. The Data Profile delivers Notes data on-demand, as you can easily and quickly create Data Profiles representing data from 100s of different sources across your Notes infrastructure.

Essential Reporting

Essential Reporting is a standard Notes database that enables an administrator to easily configure their environment in single afternoon to deliver on-demand reporting against any database. There is no coding necessary to implement Essential Reporting, instead this powerful reporting tool functions by leveraging Data Profiles to extract data from any source and deliver it in XML or JSON format.

excel reporting on domino databases

Essential Reporting then utilizes a configurable document called a ‘Report Template’ for displaying information from the Data Profiles in Excel. Once a Report Template has been configured, end users can easily RUN & RERUN reports leveraging these templates from a simple drop down menu.  Selection of a report will result in a local Excel file being created on the user’s file system, with data from the selected Data Profile automatically imported and the default report drawn and delivered.

From there, the default Excel file can be modified and extended, either via the built-in Essential Pivot Table and Chart Wizard, or using standard Excel techniques.  The extended Excel file can then be re-attached to the Report Template enabling an iterative process that delivers real business intelligence.  All subsequent calls for the report will render the most recent data, and display it in the extended format.

 

Essential Web

Essential Web is about removing the barriers that make it so difficult to form meaningful uses of Notes applications over the web on thin clients. Essential Web starts with Essential Views, which more-or-less mirrors the View functionality incorporated in the SQL development world.

Essential Views uses easily-configured Notes documents called View Profiles to describe how a thin-client should render data from selected Data Profiles to display in web view.  After selecting a Data Profile, users of the View Profile select which columns will be available in the rendered thin client view.

Once the View Profile has been saved and opened in a browser it can be used and reused over and over again. Any end user can easily format and reformat the view via drag and drop configuration to create something specific to their needs. These new iterations of Views can then be saved and shared with others.  Much like extending the Excel templates in the reporting sphere, extending the View Profile iteratively builds meaningful results in no time.

Essential Views are ABLE.  By that we mean right after creation, they are searchable, filterable, customizable, sort-able, printable and exportable

.