Creating Reports

Once data is went trough the Staging Area, cleansed, transformed and loaded into the Datawarehouse 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 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 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

Report Creation Wizard

Video Tutorials

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL forum

  • knowledgebase/creating_reports.txt
  • Last modified: 13/04/2019 17:24
  • by admin