Creating Reports

Once data is going through 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 the current warehouse stock level.

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

The 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.