Once the data is went through the Staging Area, cleansed, transformed and loaded into the Data warehouse it is presented to the End Users.

There several different types of data warehouse users.

  • Advanced Users
  • Regular Users
  • Casual Users

Advanced users design reports themselves and performs complex analytical tasks. They use very expensive reporting tools such as Business Objects, Crystal Reports or QlikView.
Regular users use reports designed by somebody else or they can use dashboards to monitor key parameters.
Casual users use reports from time to time or they may receive reports by email.

Quite often people just want to run one report per day, for example, print the current warehouse stock level.

Cost of ownership

Divide licence cost of reporting software by a number of reports use and take into account the cost of hardware=Cost of ownership

Cost of ownership is very high for casual and some of the regular users

One of the solutions is to use Active Table Editor

The administrator designs for Reports and Data Entry Forms. All this complexity is hidden from the end-user. End users can only Print reports allowed by the administrator

Active Table Editor allows the administrator to log in and design the look of the application for the end-users. You can edit user menus, security settings, menu items, input forms and reports. All this complexity is left behind the scene for the end-users. Once logged in, the end users see and edit the data, which was defined by the administrator.

Report Designer

Active Table Editor - Report Designer

Print Preview

Active Table Editor - Printing Report

Report creation wizard

Report Wizard

Video Tutorials

Direct link, no registration required.