Vision • Experience • Commitment

BackgroundBackground

Background

Alan Miles has provided a wide range of computer related products and services as an innovator, developer and IT Manager for small to medium businesses.
Automated WeighingAutomated Weighing

Automated Weighing

Automated Weighing - various applications in dairy and meat industries. Automated milk powder weighing and packaging applications. Convenient weighing, grading and record keeping in meat processing.
BizTermBizTerm

BizTerm

BizTerm™ is a telnet terminal emulator compatible with Windows 7 specifically designed for Pick Systems® D3® multidimensional database.
CrusaderCrusader

Crusader

Crusader is an integrated Enterprise Resource Planning (ERP) and financial management solution.
Dough ConsistencyDough Consistency

Dough Consistency

Dough Consistency Controller that automatically adjusts for water content in bread dough.
EDI ServerEDI Server

EDI Server

Business to business electronic document exchange including e-mailed purchase orders, invoices and statements, and various graphically printed documents.
Email ServicesEmail Services

Email Services

An e-mail services facility that allows e-mails to be scheduled on a regular basis, to deliver a wide range of reports.
Enterprise ExplorerEnterprise Explorer

Enterprise Explorer

Enterprise Explorer™ is a business intelligence tool that is intuitive, flexible, comprehensive, and quick to use.
Environmental MonitorEnvironmental Monitor

Environmental Monitor

Environmental Monitoring used in coolstores and greenhouses.
MVMirrorMVMirror

MVMirror

MVMirror is a real-time bidirectional gateway between D3 and SQL Server databases.
Older ProjectsOlder Projects

Older Projects

Summary of early projects and clients
Production MonitoringProduction Monitoring

Production Monitoring

This system was an early and very successful attempt to automate specific manufacturing business processes and monitoring not just the rate of production, but the reasons for and period of down-time.
Timber TreatmentTimber Treatment

Timber Treatment

Automation of a timber pressure treatment plant for the preservation of timber.
Energy ManagementEnergy Management

Energy Management

Automated control of energy usage to reduce cost while maintaining asdequate environmental conditions and production processes.
Energy Management Brochure 1Energy Management Brochure 1

Energy Management Brochure 1

Energy Management Brochure Page 1
Energy Management Brochure 2Energy Management Brochure 2

Energy Management Brochure 2

Energy Management Brochure Page 2
Energy Management Brochure 3Energy Management Brochure 3

Energy Management Brochure 3

Energy Management Brochure Page 3
Energy Management Brochure 4Energy Management Brochure 4

Energy Management Brochure 4

Energy Management Brochure Page 4
Energy Management Brochure 5Energy Management Brochure 5

Energy Management Brochure 5

Energy Management Brochure Page 5
Energy Management Brochure 6Energy Management Brochure 6

Energy Management Brochure 6

Energy Management Brochure Page 6

Enterprise Explorer

Enterprise Explorer™ is a business intelligence tool that is intuitive, flexible, comprehensive, and quick to use.  It pulls together the combined resources of Microsoft® SQL Server, SQL Server Reporting Services and SQL Analysis Services into a single user interface that provides an intuitive and flexible look at information in a familiar Microsoft® Windows® Explorer format.

Enterprise Explorer


A user can browse information in several different modes;

Folder View


Folder View – data can quickly be browsed and the relationships between various entities within the system examined, offering the ability to quickly and easily navigate through many thousands of customers and products to find the information required.


Profile View


Profile View – quickly locate information of interest and view predefined reports (referred to as “profiles”) that relate to that level.  Different reports can be defined for each of the different levels of folders and entities.


Data View


Data View – information can be viewed flexibly using a pivot table style of tool.  This allows a user to define particular aspects of the data of interest.  Both summarised and detailed data views can be quickly constructed.  Data can be sorted, filtered and broken down to any extent available within the data structures.  Coloured shading can be applied to highlight trends.  Although very powerful for spontaneously creating a one-off view, any such view defined by a user can be saved for reuse at a later time.

In addition, Enterprise Explorer provides;

  • Quick and convenient access to various other pre-defined reports – available from drop-down lists located with the associated data.
  • All profile and data views are capable of being exported as Excel™ spreadsheets or Adobe® Acrobat® documents in PDF format.

Predefined Reports

The client program is very simple to install.  The configuration work is done entirely in the server-side models created in the SQL Server database, Analysis Services OLAP cubes and SQL Reporting Services.

The data structures displayed in Enterprise Explorer are based entirely on the structures defined in the OLAP cubes to which it attaches.  We developed a cube for Microsoft Dynamics NAV® for demonstration purposes, but depending on any client’s use of the system, this can and should be customised.

Similarly, the various “profiles” displayed at each node need to be set up as reports.  Some default profiles are available, but these need to be customised.

Enterprise Explorer is limited only to the extent that Microsoft SQL Server, Analysis Services and Reporting Services are limited, as it is simply a client program used to access these resources.

Software made in New Zealand

Copyright © 2020, Amba Limited, Whanganui, New Zealand. All Rights Reserved.