The Viewer Edition is used to view pre-defined reports. Viewer Edition is currently available for the Web only.
The User Edition is used by end users to perform ad hoc-query, reporting, analysis and web publishing.
The Administration Edition is used to create and maintain the "End User Layer" (EUL) which is a metadata layer that hides the complexity of the database from end users.